sorting customer name and IP with value

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
 
K

kokhong

:
may be i have to change the other way to tell you the problem and the way i
plan to solve it: below is my excel file:
A B C
IP address customer name value
10.10.10.1 Lee 10
10.10.10.11 Lee 30
10.10.10.2 wong 30
10.10.10.9 wong 16
10.10.10.3 chan 40
10.10.10.4 chan 15
10.10.10.5 Kee 35

let say username lee is appeared in the list twice.two value of lee will be
compare, the lee with count 30 will be highlight. For user name wong will do
the same, two value of wong will be compare,wong with 30 will be highlight.
chan 40 will be highlight, kee will be highlight even appear once.

lastly, sort all the highlight columns to the top of the list..

any way to do it?thanks..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top