Showing Duplicate Items

Hi all

Can anybody help me please

I have a list of line items and I want to be able to see how many duplicates in Column A and B.

Column A has text field and column B is a numeric field

I thought I could use INDEX MATCH but I'm unsure.

Can anyone help me with a solution?

Thanks
CD

Is the data sorted (by A & then B) ?

Which version of XL are you running ?

Assuming unsorted... and that you want to see how many lines contain the same values as a given line (ie how many times A & B combo appears in the whole A:B range)

XL2007

C1: =COUNTIFS(A:A,A1,B:B,B1)

Pre XL2007

C1: =SUMPRODUCT(--($A$1:$A$1000=$A1),--($B$1:$B$1000=$B1))

or create a concatenation of A & B in C

C1: =$A1&":"&$B1
copied down for all rows and then use COUNTIF

D1: =COUNTIF(C:C,C1)