I am trying to locate rows which contain duplicates based on two columns. It is a little hard to explain but let me try. Below is a picture on what I am trying to achieve.
If an ID value (Column B) has a duplicate and the values in the IDF's (Column C) are different it needs to highlight the column or in Column D provide some text which I can use for conditional formatting.
- Rows 5-7 have the same ID but there is a different IDF value in one of the fields, therefore it needs to be highlighted
- Rows 9-10 have the same ID and all of the IDF values are the same, no further action is needed
- Rows 11-15 have the same ID but there is different IDF values so all of the rows relating to that ID need to be highlighted
- Row 3 has only one ID value row therefore no further action is required
This is a little hard to explain, but please. Let me know if it makes sense or if you need any more information.
Also Note: This data will be sorted by ID (unlike the example shown above)