hungledink
Board Regular
- Joined
- Feb 20, 2012
- Messages
- 88
- Office Version
- 365
I have 2 columns of data in an excel workbook. The columns both caontain values although the number of rows in each column woud be different.#
I want to compare the 2 rows for identical data which I've been able to do using the conditional formatting and highlighting duplicates.
I have an issue, however, in that the same value may appear more than once in either column. If this happens then I wanted that highlighted in another colour.
I've attached an image with the result I'm after, where cells highlighted yellow, appear in both columns but only once. Cells highlighted in blue appear multiple times in either column, but not the same number of times in the other column. And then the green cell is a value that only appears in one of the 2 columns.
Can anyone help?
I want to compare the 2 rows for identical data which I've been able to do using the conditional formatting and highlighting duplicates.
I have an issue, however, in that the same value may appear more than once in either column. If this happens then I wanted that highlighted in another colour.
I've attached an image with the result I'm after, where cells highlighted yellow, appear in both columns but only once. Cells highlighted in blue appear multiple times in either column, but not the same number of times in the other column. And then the green cell is a value that only appears in one of the 2 columns.
Can anyone help?