I would like to be able to use a worksheet function within a formula to find all occurancies of data in a list.
I have tried the VLOOKUP but it only displays the first occurance.
Whats the best method to use?