Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
any script to sort following list?
i have the following IP address, customer name and value A B C IP address customer name value 10.10.10.1 Lee 10 10.10.10.2 wong 30 10.10.10.3 chan 40 10.10.10.4 chan 15 10.10.10.9 wong 16 10.10.10.11 Lee 30 10.10.10.5 Kee 35 after sorting( compare the value of the same customer name, choose the highest value and sort to the top, other value with same name sort to bottom. Then continue compare the value of the same customer name,repeat the process again. lastly, the customer appear one in the list will be sorted at the bottom of the highest value of the same customer name) after sorting A B C IP address customer name value 10.10.10.3 chan 40 10.10.10.2 wong 30 10.10.10.11 Lee 30 10.10.10.5 Kee 35 10.10.10.1 Lee 10 10.10.10.9 wong 16 10.10.10.4 chan 15 May be what i explaining here is quite confusing, hopefully you all can understand..thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
customer Name against Unique customer number count | Excel Worksheet Functions | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
Sorting customer names | Excel Discussion (Misc queries) | |||
To get customer list | Excel Worksheet Functions | |||
Sorting Customer | Excel Discussion (Misc queries) |