Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUPS
I have data in the following format:
Name Date Amount Johnson 6/1/06 $100 Johnson 6/6/06 $300 Johnson 6/13/06 $350 Smith 6/2/06 $450 Smith 6/5/06 $100 Jones 6/16/06 $225 Every month the amount of times the name shows up will be different as well as the dates they used the money. I have different sheets for each name but i need to pull the dates and amounts into seperate columns being: Date Amount Any help is greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookups error message | Excel Worksheet Functions | |||
VLOOKUPS: Limits on # per sheet? | Excel Discussion (Misc queries) | |||
what is the maximum number of vlookups in a given workbook that E. | Excel Worksheet Functions | |||
Vlookups | Excel Discussion (Misc queries) | |||
Vlookups | Excel Worksheet Functions |