ExcelBanter - find time and text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - find time and text (https://www.excelbanter.com/excel-worksheet-functions/192864-find-time-text.html)

Atishoo

find time and text

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!

Bob Phillips

find time and text

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

"Atishoo" wrote in message
...
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!

All times are GMT +1. The time now is 08:34 AM.