View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kokhong kokhong is offline
external usenet poster
 
Posts: 19
Default highlighting and sorting

is there anyway to do following task:

A B
C
IP Username
hits
10.10.10.1 Lee
10 ----highlight
10.10.10.22 Lee
5
10.10.10.11 wong
30 -----highlight
10.10.10.9 wong
15
10.10.10.10 chan
3 -----highlight

1. highlight all the same user name with highest hits among same user name.
2. highligh all the unique user name. (example chan)
3. sort all the highlight columns to the top.

any way to do this?thanks in your advance..
after sorting
A B
C
IP Username
hits
10.10.10.1 Lee
10 ----highlight
10.10.10.11 wong
30 -----highlight
10.10.10.10 chan
3 -----highlight
10.10.10.22 Lee
5
10.10.10.9 wong
15

if highlighting procedure cannot make it, it is ok..as long as the thing can
be sorted as above,finally.thanks..