How to get the value in the last filled cell of a column

  • Thread starter Thread starter Davy
  • Start date Start date
D

Davy

Hi!
I need to get the value in the last filled cell of a
column. My cells in the column have values - either TRUE
or FALSE or <blank>. I need to get the last cell value in
the column (only the TRUE and FALSE, I don't need to take
in the blanks). I tried - =OFFSET(C1,COUNTA(C:C)-1,0) but
since I have the blanks also, the value that I get is the
<blank> and not the 'FALSE' which is the last filled value
in cell C33 and which is what I need

Column Number Value
C22 FALSE
C23 FALSE
C24 FALSE
C25 FALSE
C26 FALSE
C27 FALSE
C28 FALSE
C29 TRUE
C30 FALSE
C31 FALSE
C32 FALSE
C33 FALSE
C34
C35


Does anybody have any suggestions?

Thanks!
Davy
 
=INDEX(C:C;MAX(ROW(1:65535)*(C1:C65535<>"")))

Example for column C
Array entered
Ctrl-Shift-Enter
 
It tells me that there is an error in the formula.
The cursor then stands at the end - INDEX(C:C<here the
cursor stands>. Is there some issue with the range?
 
There's one more thing. The values are in Column C. And
whenever there is a change in the worksheet, the cells
keep being filled downwards. Now, I need to get the last
value of the column and put it in say J2. This cell J2
should keep getting updated with the latest value. I don't
want to have the formula repeated downwards. The last
filled value in the cell (which keeps changing
dynamically - the ranges change dynamically) should be
updated in cell J2.
For example, first the cells C2 to C5 are filled with True
or False. The rest of the cells are <blanks>. So, I want
the value in C5 to be in J2.
Next, the cells filled will be C2 to c8. Then I need the
value of cell C8 to be in J2.

Let me also tell you that Cells in column C are filled
based on the formula - =IF(G23<>" ",AND(G23=1,F23=0),"")

Thank you!

Davy
 
Back
Top