Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

VLOOKUPS

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brett - 21 Jun 2006 15:40 GMT
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!
Cillian - 21 Jun 2006 16:28 GMT
Hi Brett,

could you give an example of how you want the data to look?
Signature

Cillian

> I have data in the following format:
>
[quoted text clipped - 15 lines]
>
> Any help is greatly appreciated!
Brett - 21 Jun 2006 16:35 GMT
JOHNSON
Date               Amount
6/1/06            $100
6/6/06            $300
6/13/06          $350

> Hi Brett,
>
[quoted text clipped - 19 lines]
> >
> > Any help is greatly appreciated!
Marcelo - 21 Jun 2006 17:53 GMT
Hi Brett, did you try a Pivot Table?

HTH
Regards from Brazil
Marcelo

> JOHNSON
> Date               Amount
[quoted text clipped - 25 lines]
> > >
> > > Any help is greatly appreciated!
Brett - 21 Jun 2006 18:12 GMT
I thought about the same thing but my boss wants it to be in the format i
have listed.  Thanks anyways

> Hi Brett, did you try a Pivot Table?
>
[quoted text clipped - 31 lines]
> > > >
> > > > Any help is greatly appreciated!
Brett - 22 Jun 2006 14:50 GMT
Would a pivot table be the only way to do this?

> I have data in the following format:
>
[quoted text clipped - 15 lines]
>
> Any help is greatly appreciated!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.