logandiana
Board Regular
- Joined
- Feb 21, 2017
- Messages
- 107
I am sure it's something super simple, and it may be something that can be solved with out VBA.
I am looking to highlight the cell of up to the first 3 instances of a unique value in a column. The column might have the unique value twice or maybe 15 times.
Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am looking to highlight the cell of up to the first 3 instances of a unique value in a column. The column might have the unique value twice or maybe 15 times.
Thanks
[TABLE="width: 500"]
<tbody>[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B highlight[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]