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")
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Column A
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Column C
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]b
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]b
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3
[/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[/TR]
</tbody>[/TABLE]
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")
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Column A
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Column C
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[/TR]
[TR]
[TD="align: center"]a
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]b
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]b
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1
[/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]3
[/TD]
[/TR]
[TR]
[TD="align: center"]c
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2
[/TD]
[/TR]
</tbody>[/TABLE]