Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Any help will be very appreciated!
Is there any way that I can custom sort a list in this way: I made up the list below. Item Amount Number 1234 500 1234 20 1234 350 1234 95 5678 400 5678 200 5678 10 9101 600 9101 50 9101 5 9112 85 9112 155 9113 450 9115 256 first to have the Item number with the largest amount and then the same item number with their corresponding amount from high to low then have the second largest amount by item number and then the same item number with corresponding amount from high to low. For example: The item number with largest amount is 9101 with amount 600, 50 and 5. Second item with the largest amount is 1234 with amount 500, 350, 95 and 20. And so on... I want the list will be sorted in this way: Item Amount Number 9101 600 9101 50 9101 5 1234 500 1234 350 1234 95 1234 20 9113 450 5678 400 5678 200 5678 10 9115 256 9112 155 9112 85 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Sorting | Excel Discussion (Misc queries) | |||
urgent solution needed to 'custom view' re-calculation problem! | Excel Discussion (Misc queries) | |||
Custom Formats | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom Views in Shared workbook | Excel Discussion (Misc queries) |