Highlight duplicates values in a report if not all columns are duplicated
Content
I have a report with, say, 4 columns. Two lines of the data have identical values in 1 column, but not the other columns. I want those two lines to be highlighted/flagged somehow (exception?)
| Name | Opportunity ID | Amount | Address |
|---|---|---|---|
| John Smith | 1001 | £99.99 | 1 High Street |
| Jane Jones | 1002 | £50.56 | 1 Main Street |
| Jane Jones | 1002 | £50.56 | 56 High Road |
| Peter Person | 1568 | £525.45 | 91 Low Close |
In this case, the Opportunity ID for rows 2 and 3 would be highlighted red.
Is this possible? If so, how?
---
TIA,
Neil
Version
May 2016
Tagged:
0