comapering two sheets in excel 2010
hello,
i have two sheets which i need to compare. sheet1 is one big data table (name of streets, numbers and adds to numbers) with 3 collums street name, number, add to number ADOLFA VEBERA 5 ALBAHARIJEVA 0 BB ALBAHARIJEVA 1 H ALBAHARIJEVA 3 G ALBAHARIJEVA 5 ALBAHARIJEVA 7 ALBAHARIJEVA 9 in sheet2 i have same 3 collums Adolfa Vebera 5 Ilica 191 G1 Ilica 232 DV Ilica 254 Jadranska 2 DV Jordanovac 51 2 my task is to search if values from sheet2 are in sheet1 (in all 3 collums) THX in advance |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com