Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting names by start time
Well i tried to figure out a formula to help me out but unfortunately i have
had no luck. I thought i had it with this formula but no. I also tried a transpose but couldnt get it to work. =IF(EXACT(INDEX(T:T,MATCH("TS11:00 - 19:00",T:T,0)),W3),INDEX(R:R,MATCH("TS11:00 - 19:00",T:T,0)),"") So is there a way to sort this these people by the time they start? Column B is not really needed because i also need to sort by position. Any help would really be appreciated, Thank you. info comes out like this name start time start time with position A b c name1 7:00 t7:00 name2 7:00 t7:00 name3 10:00 ts10:00 name4 10:00 t10:00 name5 12:00 ps12:00 name6 12:00 ts12:00 name7 12:00 t12:00 name8 14:00 t14:00 name9 16:00 p16:00 final result wanted t7:00 ts10:00 ps12:00 t14:00 p16:00 name1 name3 name5 name8 name9 name2 t10:00 t12:00 name4 name7 ts12:00 name6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting names by start time
Just figured it out. I added SUM to the match part of the equation so that
when it gets a result it will add 1 to get next result =IF(EXACT(INDEX(T:T,SUM(1,MATCH("TS11:00 - 19:00",T:T,0))),W3),INDEX(R:R,SUM(1,MATCH("TS11:00 - 19:00",T:T,0))),"") "NunRacer" wrote: Well i tried to figure out a formula to help me out but unfortunately i have had no luck. I thought i had it with this formula but no. I also tried a transpose but couldnt get it to work. =IF(EXACT(INDEX(T:T,MATCH("TS11:00 - 19:00",T:T,0)),W3),INDEX(R:R,MATCH("TS11:00 - 19:00",T:T,0)),"") So is there a way to sort this these people by the time they start? Column B is not really needed because i also need to sort by position. Any help would really be appreciated, Thank you. info comes out like this name start time start time with position A b c name1 7:00 t7:00 name2 7:00 t7:00 name3 10:00 ts10:00 name4 10:00 t10:00 name5 12:00 ps12:00 name6 12:00 ts12:00 name7 12:00 t12:00 name8 14:00 t14:00 name9 16:00 p16:00 final result wanted t7:00 ts10:00 ps12:00 t14:00 p16:00 name1 name3 name5 name8 name9 name2 t10:00 t12:00 name4 name7 ts12:00 name6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) |