Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Greetings,
I need a date for specific product purchase. The data provided me was arranged as follows: Customer IDs in column A. Subsequent columns are alternating between product ID and Date. I only require the date of purchase for product K5, however each customer may have that product listed in a different column from others. Small example to illustrate; I apologize as the formatting will not appear correct: Customer ID Product Date Product Date Product Date 1234 A1 1/2/10 B4 12/1/09 K5 10/12/06 3324 K5 9/22/08 A1 3/14/07 B4 2/28/04 9845 B4 1/13/09 K5 6/29/03 A1 12/12/23 Thanks in advance for any suggestions! Regards, Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help in extract of data | Excel Discussion (Misc queries) | |||
Tying to extract all data from a pivot pulling from external data | Excel Discussion (Misc queries) | |||
data extract | Excel Worksheet Functions | |||
How to extract the data | Excel Worksheet Functions | |||
Extract Data | Excel Discussion (Misc queries) |