what excel function to use

[MINAL ZUNKE]

Hi All,

I have 2 excel workbook named A and B.

In workbook A, I have 4 worksheet 1, 2, 3, 4. In each worksheet (1,2,3,4)
under Column B are various part number.

In workbook B, I have 5 worksheet 1, 2, 3, 4, 5. In each worksheet
(1,2,3,4,5) under Column B are various part number.

Excel should check for repeat part number in all worksheet n highlight them
with blue (colour could be anything)

Best Regards,
Minal

 

[Eduardo]

Hi,
take a look into CPearson web

http://www.cpearson.com/Excel/Duplicates.aspx

if this helps please click yes, thanks

 

[JP Ronse]

Hi Minal,

Chip Pearson has written some formulas to find and highlight duplicates in
an array.

http://www.cpearson.com/excel/Duplicates.aspx

Chip's formulas are handling only 1 worksheet range, so not sure if it is
extendable to more worksheets & workbooks.

Wkr,

JP