Matching Data

[hardeep.kanwar]

Hi! Experts

I have 2 sheets in a workbook.Sheet1 is a master sheet with Customer code and there Sale.And Sheet2 is the sheet which has only Customer code.

Note: Its just a Example i have total 1924 data.

Now in Sheet 1 there are some Customer code which is Repeated some times 2 and 3 or even 4 times.


In Sheet 2 Same as sheet 1 there are some data which is also Repeated.

Now i how can i know which Customer Code in sheet 2 Missing from Sheet1

I have Colored Some Data in sheet 2 which is not match with Sheet1

For Example.
In Sheet 1 221000000232 is repeated 2 times but in Sheet2 has only 1 times.

Could anybody Tell me how can i do that.

Thanks in Advance

Hardeep kanwar

[windknife]

Using countif can solve your problem. You can see sample as attached.
HTH, windknife

[hardeep.kanwar]

Gr8 WindKnife

Works like Treat

Thanks Again

Hardeep kanwar