VLOOKUP
I have several spreadsheets with customer numbers that I need to compare
against one another. Currently, I have all my sets of customer numbers in different spreadsheets. I need to compare each of these spreadsheets to one another to find the overlaps of customers. The only way I can think of doing this is by doing vlookup individually. For example,sheet A compared to sheet b and then vice versa. Is there an easier way of doing this with Vlookup? |
VLOOKUP
Chip has lots on duplicates at www.cpearson.com
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Vindell" wrote in message ... I have several spreadsheets with customer numbers that I need to compare against one another. Currently, I have all my sets of customer numbers in different spreadsheets. I need to compare each of these spreadsheets to one another to find the overlaps of customers. The only way I can think of doing this is by doing vlookup individually. For example,sheet A compared to sheet b and then vice versa. Is there an easier way of doing this with Vlookup? |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com