Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help collecting data please!
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help collecting data. | Excel Discussion (Misc queries) | |||
collecting data from one sheet to another | Excel Discussion (Misc queries) | |||
Collecting data from worksheets. | Excel Worksheet Functions | |||
collecting data | Excel Discussion (Misc queries) | |||
Collecting and exporting data | New Users to Excel |