Headline31
New Member
- Joined
- Nov 30, 2017
- Messages
- 13
I am looking for a way to file through thousands of lines of data and to pick out certain duplicate items. I feel like I am just spitting out all of my thoughts, but hopefully someone will understand the gist. Using this table as an example, the thought train goes like this:
1. Check if column A has duplicates
No: skip
Yes: check if Column C has more than 1 unique item
No: skip
Yes: highlight all duplicate cells in Column A through Column C
***IF column A has a duplicate AND column C has more than 1 unique item, THEN highlight***
With that train of thought, all cells with "a" and "c" would be highlighted (including the blank cell in column C for "a")
<tbody>
</tbody>
1. Check if column A has duplicates
No: skip
Yes: check if Column C has more than 1 unique item
No: skip
Yes: highlight all duplicate cells in Column A through Column C
***IF column A has a duplicate AND column C has more than 1 unique item, THEN highlight***
With that train of thought, all cells with "a" and "c" would be highlighted (including the blank cell in column C for "a")
Column A | Column C | |
a | 1 | |
a | 2 | |
a | ||
b | 1 | |
b | ||
c | 1 | |
c | 3 | |
c | 2 |
<tbody>
</tbody>