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. |
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. |
All times are GMT +1. The time now is 07:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com