Comparing two excel sheets

Devi - Mar 18, 2015 at 01:18 AM

I am really sorry madam/sir, in a hurry i saw only the content. I would be thankful if you solve this issue.

i have 2 excel sheets, in one sheet list of numbers like 24, 48,75,104 etc., and in other sheet i have random of numbers like 1, 4, 23, 24, 56, 75, 68, 306 etc., in this i need to know whether the numbers in sheet 1 are repeated in sheet 2. in both the sheets more than 1000 random numbers are there. kindly solve this problem.

Hope you will do the needful.