Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Hi, Lets say I have a list of Sales Reps in column A, Turnover Figures in B, Cost Value in C, Margin in D etc etc....... I need to sort them, sometimes by Rep, some times by Margin ascending, sometimes by Turnover Ascending etc etc. Are there any formulas I can use to do this instead of using the sort function EVERY TIME Cheers Guys -- sammy2x ------------------------------------------------------------------------ sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674 View this thread: http://www.excelforum.com/showthread...hreadid=512169 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Hi Sammy, Have a look at Dave's suggested technique on Debra's site: http://contextures.com/xlSort02.html btw, there is a very similar thread to yours which is recent & where I saw this link - I just can't find it at the moment. Hth, Rob Brockett NZ Always learning & the best way to learn is to exxperience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=512169 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . | Excel Discussion (Misc queries) | |||
sorting number in ascending order | Excel Discussion (Misc queries) |