I have two columns A1 (Section X) and B1 (Section Y)
Each column has 20 rows of data (A2-B21) such as:
X Y
1 33
2 34
3 35
4 36
5 37
3 35
7 39
8 40
9 41
10 42
11 43
12 44
10 42
14 46
10 42
16 48
17 49
18 50
19 51
20 52
What I need is either dynamic formula or macros that can do the following:
1) Assess range A2-B21;
2) Identify sets of duplicates based on the identical values in both columns - for example in this case there are two sets of duplicates:
-Set 1: A4 (4)/B4(36) is identical with A7/(4)B7(36); and
-Set 2: A11(10)/B11(42) is identical with: A14(10/B14(42) is identical with A16(10)|B16 (42)
3) Highlight cells that contain sets of duplicates with different colors – for example:
Cell color for Set (A4 /B4 & A7/B7) should be different to cell color for Set 2 (A11/B11, A14/B14 & A16|B16).
This coloring should be dynamic – data in this table is updated on adaily basis so as the number of duplicates will vary all the time.
Thanks in advance
Bookmarks