Find, count and extract duplicate cells

[Igby]

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!

 

[T. Valko]

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