Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help collecting data.
hello,
another question from the official excel newbie! any and all help is greatly appriceated guys! So I have this list i'm always talking about 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 product a 10.99 345353 product a 11.99 3445453 product a 10.99 657567 product a 8.99 345353 product a 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? so if i put in D1 that i'm searching for 'PRODUCTA' it would return something like this... 345353, 3445453, 657567, 345353, 5464646 showing me all the orders for which that product was used... is this possible and if so, how? Thanks alot guys! Brandon Roland |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collecting data from one sheet to another | Excel Discussion (Misc queries) | |||
Collecting data from worksheets. | Excel Worksheet Functions | |||
collecting data from various worksheets | Excel Worksheet Functions | |||
collecting data | Excel Discussion (Misc queries) | |||
Help with collecting data from a spreadsheet | Excel Discussion (Misc queries) |