Forum Discussion
Solved
Trying to use an index-counta formula, but the range has IF function data
I am trying to gather the most recent value inputted within a column. The base formula I am using is =INDEX(C6:C301, COUNTA(C6:C301)) However, it pulls back no data (no error, it just leaves the...
OshBerr Since your IF formula returns either a number or "", try this:
=INDEX(C6:C301,MATCH(99^99,C6:C301))It should always return the last number entered in the range, thus ignoring cells with "".
In case you are using Excel365 you could try this:
=TAKE(FILTER(C6:C301,C6:C301<>""),-1)
OshBerr Since your IF formula returns either a number or "", try this:
=INDEX(C6:C301,MATCH(99^99,C6:C301))It should always return the last number entered in the range, thus ignoring cells with "".
In case you are using Excel365 you could try this:
=TAKE(FILTER(C6:C301,C6:C301<>""),-1)
- Thank you very much, this worked!
