Hi,
I have a long list of texts that I need to count how many are distinct (the first occurrence), but only with only contains the word "LOOP" in the text, all the text are in 1 column. I know I can do this with remove duplicates, but I will constantly update the list, so I hope there is a way to automatically update the value.
sample of my texts:
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]RING1_LOOP6[/TD]
[/TR]
[TR]
[TD]RING6_LOOP4[/TD]
[/TR]
[TR]
[TD]RING5_LOOP30[/TD]
[/TR]
[TR]
[TD]RING5[/TD]
[/TR]
[TR]
[TD]RING7_LOOP40[/TD]
[/TR]
[TR]
[TD]RING1_LOOP6[/TD]
[/TR]
[TR]
[TD]RING5_LOOP30[/TD]
[/TR]
</tbody>[/TABLE]
so in above texts, the RING5 should not be counted, so the return value should be 4.
because, RING1_LOOP6, RING6_LOOP4, RING5_LOOP30, and RING7_LOOP40 only.
It will be very helpful if anyone can help me on this.
Thank you!
I have a long list of texts that I need to count how many are distinct (the first occurrence), but only with only contains the word "LOOP" in the text, all the text are in 1 column. I know I can do this with remove duplicates, but I will constantly update the list, so I hope there is a way to automatically update the value.
sample of my texts:
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]RING1_LOOP6[/TD]
[/TR]
[TR]
[TD]RING6_LOOP4[/TD]
[/TR]
[TR]
[TD]RING5_LOOP30[/TD]
[/TR]
[TR]
[TD]RING5[/TD]
[/TR]
[TR]
[TD]RING7_LOOP40[/TD]
[/TR]
[TR]
[TD]RING1_LOOP6[/TD]
[/TR]
[TR]
[TD]RING5_LOOP30[/TD]
[/TR]
</tbody>[/TABLE]
so in above texts, the RING5 should not be counted, so the return value should be 4.
because, RING1_LOOP6, RING6_LOOP4, RING5_LOOP30, and RING7_LOOP40 only.
It will be very helpful if anyone can help me on this.
Thank you!