Compare Two Lists
Posted by Sean Scott on August 11, 2000 10:36 AM
Thanks for the great page. I am a total Excel newbie and have almost zero knowledge of how it works. However, I still need help. I am extracting 2 flat files of customer lists from a unix box and opening them in Excel 97 on windows 98. #1 List contatins all customers that have purchased from us, listing customer number, name and total sales. List #2 contains all customers in the system, with customer number, name and full address. What we want is to compare the two lists and have a 3rd list generated of just the buying customers, with their addresses etc, eliminating the customers that have not purchased or have a sales total of zero.
Your help would be greatly appreciated. An exe file would be great as again, i have zero knowledge here. Thank you