K
kokhong
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
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