What I want to do is count the number of times that the combinations below appear in each row in the table of data. I've been looking all over the internet to for tutorials and tips but none have been helpful to me.
I've attached the Excel file that I'm currently using.
Here is a sample of the data I'll be using:
This is the table of data:
[TABLE="width: 64"]
[TD="width: 64"]123489[/TD]
126475
[/td]135678
[/td]134589
[/td]126789
[/td]345679
[/td]
[/TABLE]
Here is a sample list of combinations:
[TABLE="width: 64"]
[TD="width: 64"]123[/TD]
124
[/td]125
[/td]126
[/td]127
[/td]128
[/td]129
[/td]
[/TABLE]
[TABLE="width: 192"]
[TD="align: right"][/TD]
[/TABLE]
The final result should be that combination 123 appears once and combination 126 appears twice, while the other combinations don't appear at all or 0 times.
Feel free to ask any questions if this seems confusing.