Hi there,
I hope someone can help me with this problem.
I have a list of 4,000+ rows and in a seperate worksheet I have a list of values. I know how many times each value appears in the list but I need to know which rows they appear on. If each just appeared once then I could do this using match but as they appear several times and I need to know every row they appear on I do not know the best of going about this.
Could anybody help me with this please?
Many thanks in advance.
Bookmarks