Text

  • Thread starter Thread starter beano
  • Start date Start date
B

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
 
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
 
Back
Top