Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a multi-column list the I am currently sorting by
Column A value and then coloring rows with duplicate values in A using conditional formatting. How can I either sort by color, to get all the duplicate rows together (both sets of the duplicate pair)? or, use some other method to locate and separate out any rows where there are more than one of any column A value? Thanks. I think I remember seeing a posting about this a few weeks ago; but I have not been able to locate it again? Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Locating the max value AND performing a fn on it only | Excel Discussion (Misc queries) | |||
Locating duplicates within range of time punch data | Excel Worksheet Functions | |||
locating duplicates | Excel Discussion (Misc queries) | |||
Locating | New Users to Excel | |||
locating the top 5 number (in a col) | Excel Worksheet Functions |