Try this for LOGICALS:

Array entered using the key combo of CTRL,SHIFT,ENTER:

=INDEX(C1:Z1,MAX((C1:Z1<"")*(COLUMN(C1:Z1)-COLUMN(C1)+1)))

Biff

"Robert Christie" wrote in message
...
Hi Biff

They are logical values.
I could copy and paste values in place before entering your formula if
that
would help.

--
Thank you

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


"Biff" wrote:

Hi!

Are your trues and falses TEXT values and not LOGICAL values?

To find the last TEXT entry in the range C1:Z1:

=LOOKUP(REPT("z",255),C1:Z1)

Biff

"Robert Christie" wrote in message
...
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