Duplicates with multiple columns

pywhacket

Board Regular
Joined
Mar 24, 2006
Messages
84
Hello,

I need to match duplicate rows - all entries for cells in columns A-J need to be a match. I do not want to eliminate them but conditionally format them if possible because I also need to determine which rows are not duplicates.

Thanks in advance!
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Maybe something like this ?
Excel Workbook
ABC
14item1data1result1
15item1data1result1
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A141. / Formula is =A14:C14=A13:C13Abc
B141. / Formula is =B14:D14=B13:D13Abc
C141. / Formula is =C14:E14=C13:E13Abc
A151. / Formula is =A15:C15=A14:C14Abc
B151. / Formula is =B15:D15=B14:D14Abc
C151. / Formula is =C15:E15=C14:E14Abc




adjust the range as needed
 
Last edited:
Upvote 0
Well, not exactly. I would like all like rows to have the conditional formatting so that it will be evident which rows are not duplicates.
 
Upvote 0

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top