Text

[beano]

Hi All,

i have a question about finding text. if you have a list of text in
row

"A, B, C, D, E, F...etc"

in sperate cells, with blank cells in between, is there a function fo
searching along the row to return the highest letter?

Cheers,

Beano

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(1:1,MATCH(0,COUNTIF(1:1,">"&1:1)+(1:1=""),0))

adapt row 1 for your needs