List all the row numbers that this value appears in

**Jessica.Bush** · 02-21-2011, 01:45 PM

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.

**Charles** · 02-21-2011, 02:12 PM

Hi,

This link has an attachment that does a findall and place the found info in a listbox.
It's the zipped attachment.(The code will loop thru all worksheets)
You may be able to modify the code and his may help.

http://www.excelforum.com/excel-prog...h-options.html

**Paul** · 02-21-2011, 02:24 PM

The FindAll function and code is from Chip Pearson.

http://www.cpearson.com/excel/FindAll.aspx

**Greg M** · 02-21-2011, 02:28 PM

Hi there,

Take a look at the attached workbook - Sheet 2 displays the row numbers where the values on Sheet 1 occur. It may be possible to adapt this workbook to suit your specific needs.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**Jessica.Bush** · 02-22-2011, 10:03 AM

Hi everyone,

Thank you for all of your responses, it is much appreciated.

Greg, that was great, thanks, i went down this line in the and with a couple of amendments to suit my data it works perfectly!

Thanks again.