View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atishoo Atishoo is offline
external usenet poster
 
Posts: 267
Default 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!