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!
{=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!