Locating the rightmost value in a row

[cloudwalking]

Hi,

I am wondering if someone could possible help?

I have a large sparse data sheet and I am struggling to work out how to go a couple of things...

COLA - I want to return the highest value in the array c1:z1 (for instance), and if no data present then returns a blank.

COLB- I want to return the rightmost value in teh same array and also return a blank if no data present.

many thanks in advance!

[Pete_UK]

Try this in A1:

=IF(COUNT(C1:Z1)=0,"",MAX(C1:Z1))

and this in B1:

=IF(COUNT(C1:Z1)=0,"",LOOKUP(10E10,C1:Z1))

then copy down.

Hope this helps.

Pete

[bebo021999]

Highest value:
=MAX(C1:Z1)
Rightmost value:
=IFERROR(LOOKUP(2,1/C1:Z1,C1:Z1),"")

[cloudwalking]

Thank you so much!