How would I find and list a set of non-duplicate values next to the complete set

**Steve113** · 08-07-2013, 12:07 AM

Would there be a formula for this?
Please see file.

**:) Sixthsense :)** · 08-07-2013, 12:25 AM

Place the cursor in A1 Cell (Since the below formula refers to A1 Cell) and extend the selection by holding shift+Arrow keys to select the entire data you would like to highlight
Press Alt+O+D>>New Rule>>Use a formula to determine which cells to format
Copy and paste the below formula
Formula:
```
Please Login or Register  to view this content.
```
Select Format>>Fill>>Select your desired color to highlight the duplicate value
Press Ok>>Ok>>Apply>>Ok.

**Steve113** · 08-07-2013, 12:31 AM

Thank you. That is exactly what I needed.

**:) Sixthsense :)** · 08-07-2013, 12:32 AM

Glad it helps you and thanks for the feedback and rep

Re: How would I find and list a set of non-duplicate values next to the complete set