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! |
VLOOKUPS
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! |
VLOOKUPS
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! |
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! |
VLOOKUPS
I thought about the same thing but my boss wants it to be in the format i
have listed. Thanks anyways "Marcelo" wrote: 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! |
VLOOKUPS
Would a pivot table be the only way to do this?
"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! |
All times are GMT +1. The time now is 12:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com