find time and text

  • Thread starter Thread starter Atishoo
  • Start date Start date
A

Atishoo

Can anyone tell me what is wrong with this function:

{=FIND(--SMALL(--LEFT(B18:B21,4),1),B18:B21)}

returns #Value

The range B18:B21 contains a list of times and names (10:15 John s)
I want to return the contents both time and text of the one with the
earliest time!
 
=INDEX(B18:B21,MATCH(SMALL(--LEFT(B18:B21,FIND("
",B18:B21)-1),1),--LEFT(B18:B21,FIND(" ",B18:B21)-1),0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top