LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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..

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic sorting (giving max and min) based on custom sorting lis Joe Lewis[_2_] Excel Worksheet Functions 4 November 23rd 08 05:12 AM
Sorting data by highlighting? Jonathan Excel Discussion (Misc queries) 1 January 24th 08 03:23 PM
Highlighting Ed Excel Discussion (Misc queries) 0 March 8th 07 06:56 PM
Highlighting every other row? Shanfrog Excel Discussion (Misc queries) 3 January 23rd 07 05:02 PM
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. Jamie Furlong Excel Discussion (Misc queries) 6 August 28th 05 09:27 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"