Find, count and extract duplicate cells
 

Hi,

I have a number of columns and I want to be able to count the number of
duplicates in column A IF the value in column B="X" AND column C="Y".

Ideally I'd also like to be able to extract each of those duplicates and put
them into another column or spreadshhet.(I'm not sure if this is do-able!)

I'm guessing that the first bit can be done with some kind of SUMPRODUCT
formula, but I'm not sure how to include the IF/AND in with the formulas I've
found in this forum to identify duplicates.

Any help would be greatly received!

Find, count and extract duplicate cells
 

Can you provide some sample data and the result you expect?

--
Biff
Microsoft Excel MVP


"Igby" wrote in message
...
Hi,

I have a number of columns and I want to be able to count the number of
duplicates in column A IF the value in column B="X" AND column C="Y".

Ideally I'd also like to be able to extract each of those duplicates and
put
them into another column or spreadshhet.(I'm not sure if this is do-able!)

I'm guessing that the first bit can be done with some kind of SUMPRODUCT
formula, but I'm not sure how to include the IF/AND in with the formulas
I've
found in this forum to identify duplicates.

Any help would be greatly received!