Find first cell in a row not equal to
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. |
Find first cell in a row not equal to
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) -- Biff Microsoft Excel MVP "John" wrote in message ... 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. |
Find first cell in a row not equal to
Thanks - MVP you are.
"T. Valko" wrote: 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) -- Biff Microsoft Excel MVP "John" wrote in message ... 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. |
Find first cell in a row not equal to
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "John" wrote in message ... Thanks - MVP you are. "T. Valko" wrote: 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) -- Biff Microsoft Excel MVP "John" wrote in message ... 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. |
All times are GMT +1. The time now is 07:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com