View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Christie
 
Posts: n/a
Default Each rows last cell text value could be in any columns.

Is it possible using a formula, to return the last text value in a row where
the last cell text value could be in any column from C to Z.
Below is a layout example;

Row A B C D................Z result
1. ?? ?? true true
2. ?? ?? ?? true true
3. ?? ?? ?? ?? false false

TIA
--
Thank you

Regards
Aussie Bob C.
Using Windows XP Home + Office 2003 Pro SP2