So... bit stumped on this but here goes.
Say I have a list of unique values that are fruit in a vertical list
I want to be able to count how many times things in the vertical list are seen in the Horizontal list. so in the above the answer is 3 as Apple, pear & lemon are in the list.
this possible?? thinking it involves some sort of Index and count?
Say I have a list of unique values that are fruit in a vertical list
Apple | result | ||||||
Pear | 3 | apple | pear | tree | Dog | Lemon | |
Orange | |||||||
Grapes | |||||||
Lemon |
I want to be able to count how many times things in the vertical list are seen in the Horizontal list. so in the above the answer is 3 as Apple, pear & lemon are in the list.
this possible?? thinking it involves some sort of Index and count?