VLOOKUPS
Hi Brett, did you try a Pivot Table?
HTH
Regards from Brazil
Marcelo
"Brett" escreveu:
JOHNSON
Date Amount
6/1/06 $100
6/6/06 $300
6/13/06 $350
"Cillian" wrote:
Hi Brett,
could you give an example of how you want the data to look?
--
Cillian
"Brett" wrote:
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!
|