Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
How can i find time in various time zone? | New Users to Excel | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |