How do I get Excel to count identical rows in a list?

A

Ali Dennis

I have a large list of data and I need some way to get Excel to count the
number of identical rows. The list is sorted so that identical rows are
adjacent to each other. I need excel to put a number in another column
stating how many exact replicates of that row are present in the worksheet.
If possible I would also like excel to delete the replicates and leave only
one row with a count of the number of replicates it has deleted. I am using
Excel 2002 on Windows XP Professional.
 
F

Frank Kabel

Hi
how many columns are filled with data?.
you may use a formula such as
=SUMPRODUCT(--($A$1$A$100=A1),--($B$1:$B$100=B1),--8$C$1:$C$100=C1))
and copy this down for all rows
 
Top