Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HIGHLIGHTING DULPICATES WITH TWO COLUMNS & DELETING DUPLICATE
Sirs,
I request formula if Col-A & B Having Duplicate (NOT ONE COLUMN), that cells to be highlighted. (AS PER BELOW SAMPLE - ROW 1 & 5 OF COL-A & B TO BE HIGHLIGHT) And for another application, i want to delete the duplicate cells or rows.(CELL - A5 TO BE DELETE) PLEASE FIND THE SAMPLE DATA COL-A COL-B AC-A3654-023-02 2 AC-A3654-023-02 4 AC-A3655-024-03 1 AC-A3654-023-03 2 AC-A3654-023-02 2 Request you to help on this & save my time. -PERANISH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting duplicate cells in a column | Excel Discussion (Misc queries) | |||
Highlighting duplicate entries | Excel Worksheet Functions | |||
deleting duplicate cells in several columns | Excel Worksheet Functions | |||
Highlighting Duplicate Values | Excel Worksheet Functions | |||
highlighting duplicate values | Excel Worksheet Functions |