help with data collection!

[Guest]

Hello all!

Here is a c/p of partial of my post from the other forum. Any and all help
is greatly appriceated guys! Thanks!


So I have this list that has product numbers in
column A, product prices in column B, and order number for the products in
column C ... most products have more than once instance.. for example

col a col b col c
producta 10.99 345353
producta 11.99 3445453
producta 10.99 657567
producta 8.99 345353
producta 10.99 5464646

so what I'm trying to do now is , when i type in the product number(products
are alphanumeric w/ no spaces - the above is just an example) , I want excel
to search for all entries matching the product entered (A1:A2000) .. If it
finds the products I would like it to display what order numbers are tied to
that product number, maybe seprated by commas.. or spaces if thats easier!

so if i put in D1 that i'm searching for 'PRODUCTA' it would return
something like this...

345353, 3445453, 657567, 345353, 5464646


I simply want to put a alphanumeric string into a cell (say D1), the code
will search A1:A2000 for all instances of the string that is in D1 .

If the string is found in A1, it will copy the data in C1, say that the
string is found in A212, it would copy the data in C212 ... If it is found in
both A1 and A212, it would copy both values.. for up to 5 values, and display
them in a cell seperated by comma's or spaces, whichever is easier.

Please help!

Thanks,
Brandon Roland
excel newbie!

 

[Nick Hodge]

Brandon

This is not easily possible, why not use Data>Filter>Autofilter and filter
the product. this will give you a list of just orders by that product

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog