Find first cell in a row not equal to

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a spreadsheet that outlines performance to date by month. The months
are listed across a row (D31-031) with text based indicators three rows
beneath (D34-O34). This cells in row 34 are not null as they have a formula.
The formula returns "" if no data has been input for that month (rows 32 and
33).

At the far right of this I have an "Overall Status" cell (P32) that I want
to return the indicator in the most recent month containing data. I see many
array forumla solutions for numeric based questions like mine but nothing for
text. Any help out there?

zdjb
Thanks in advance.
 
This will return the *last* entry (text or numeric) in the range and
excludes formula balnks (""):

=LOOKUP(2,1/(D34:O34<>""),D34:O34)

For the *last TEXT* excluding formula blanks:

=LOOKUP(2,1/(ISTEXT(D34:O34))/(D34:O34<>""),D34:O34)
 
Thanks - MVP you are.

T. Valko said:
This will return the *last* entry (text or numeric) in the range and
excludes formula balnks (""):

=LOOKUP(2,1/(D34:O34<>""),D34:O34)

For the *last TEXT* excluding formula blanks:

=LOOKUP(2,1/(ISTEXT(D34:O34))/(D34:O34<>""),D34:O34)
Click to expand...
 
Back
Top