find time and text

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!
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top