View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Need help with custom sorting

Did you try it?

And I don't think that this is close to a custom list.

etronis wrote:

Dave Peterson wrote:
see your first post.

etronis wrote:

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


--

Dave Peterson


Thanks,

But what I want is to tell excel to sort Item Numbers by the largest
amount, so if there is one Item Number with several Amounts, and only
one of these Amounts is the largest one in the list, then excel will
sort this Item Number first even the rest of Amounts for this Item
number might be smaller than other Amounts belonging to the other Item
Numbers. Then excel will pick Item Number will second largest Amount
and sort its amounts....Refer to the list above, which i sorted
manually. I was wandering whether Excel has capabilities to build a
custom list that will generate this kind of sorting.

Thank you


--

Dave Peterson