I have a couple of problems that are beyond my excel knowledge; I would much appreciate it if any could help me on this?
I have one bulk list and one unique list that I have removed the duplicates out of. Now what I would like to do I compare my unique list to the bulk list and in another column display how many instances of each word in the unique column are in the bulk list.
For instance next to each word in the unique list I would like to it display a number, so a 3 next to my unique list would mean that particular word was in the bulk list three times?
Can anyone figure out a method to achieve this?
Thanks again Marx