Compare 2 excel sheets

Closed
Devi - Mar 16, 2015 at 08:20 AM
Hello,

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.