Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting data by highlighting? | Excel Discussion (Misc queries) | |||
Highlighting | Excel Discussion (Misc queries) | |||
Highlighting every other row? | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |