Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steve
 
Posts: n/a
Default Comparing multiple lists

Here's my situation.

I have three lists, each with a vendor and amount paid that vendor for that
year. The lists are about 200 lines in lenth. I'm trying to chart each
vendor's spending for unusual growth between the three years. Is there an
effecient way to align the vendors so that I can do this? Vendors used year
to year vary, but many stay the same. Any help is greatly appreciated.
Thanks.
  #2   Report Post  
Paul
 
Posts: n/a
Default

Steve

You can use the PATools Data Toolkit at http://ukww.net/patools to do this.

HTH
Paul

"Steve" wrote in message
...
Here's my situation.

I have three lists, each with a vendor and amount paid that vendor for

that
year. The lists are about 200 lines in lenth. I'm trying to chart each
vendor's spending for unusual growth between the three years. Is there an
effecient way to align the vendors so that I can do this? Vendors used

year
to year vary, but many stay the same. Any help is greatly appreciated.
Thanks.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
comparing lists Prixton Excel Discussion (Misc queries) 1 February 26th 05 07:04 PM
Can I get the mode, min, and max with multiple criteria? BobT Excel Discussion (Misc queries) 1 February 15th 05 03:20 AM
Comparing 2 Customer Lists to Identify Shared Customers carl Excel Worksheet Functions 2 January 26th 05 07:17 PM
XML / parent with multiple children and with multiple children Richard Excel Discussion (Misc queries) 0 January 5th 05 11:49 AM
How do I avoid saving multiple Excel/Wordfiles for versioning purp Neil Excel Discussion (Misc queries) 1 December 13th 04 12:57 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"