Find and Highlight duplicates in non-adjacent columns

[kevinmcilroy]

I have multiple non adjacent columns where i want to highlight when a duplicate occurs in one of the preceding columns.

The columns are filled in A to I, so therefore after all entries are entered into A i need any duplicate entries entered into C to be highlighted. Then any entries in A or C if duplicated in E highlighted, entries in A, C or E entered into G highlighted and so on.

Basically the 20 entered in C would be highlighted because its also in A, in E the 34 would be highlighted as its also in A and the 55 highlighted because its in C

	A	B	C	D	E	F	G	H	I
1	34		20		87		12		56
2	20		33		85		13		47
3	56		11		34		14		39
4	78		55		80		15		28
5	23		99		55		78		12
6	12		39		10		14		33
7	13		45		30		66		77

<tbody>
</tbody>

 

[Rick Rothstein]

You show the duplicates being colored differently from each other... is that a requirement? If so, how big is your data base and what is the maximum number of sets of duplicates you expect to ever have?

 

[kevinmcilroy]

Hi Rick,

No the duplicates don't have to be coloured differently, thats just to better show the duplicates in the example.

Will not have more than 12 columns of duplicates and likely to be no more than 300 rows

Ideally, I'd like to have the cell to be highlighted yellow if possible so that it stands out rather than the actual data itself