ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comparing multiple lists (https://www.excelbanter.com/excel-worksheet-functions/15594-comparing-multiple-lists.html)

Steve

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.

Paul

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