Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicate in Row
Hello All:
Here is my dilemma…..I am using Excel 2007. I have a spreadsheet with 17,3322 row of data that spans to Column W (A2:W173322) excluding the header. I am trying to do conditional formatting to bring to light the duplicate values that are identical across the row and highlight them. The problem is that the built in function is highlighting duplicates whenever it finds it. I need to somehow only highlight if the entire row is duplicate and not only portion. A2:W2 is the entire row which represents a data set. I tried using =COUNTIF ($A$2:$W $173322,A2)1 but it is not quit working. Any Ideas……. Ardy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate | Excel Discussion (Misc queries) | |||
Duplicate | Excel Discussion (Misc queries) | |||
last duplicate value | Excel Programming | |||
How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
duplicate | Excel Discussion (Misc queries) |