list of duplicates

Occasional Contributor

What formula can display duplicate rows on a spreadsheet as a list with all the row numbers?

 

The range would be A1:F462256.  It's a big list.  I don't want to highlight the duplicates.  I want to have a separate list that tells me all the duplicates so they can be fixed after the duplicates are filtered out.

 

Thank you in advance!

 

2 Replies
Which column(s) determine if a record is a duplicate?

You can use COUNTIF Formula to know how many number of times a value is being repeated in a row. 

 

=Countif(A:A, A1)

 

Hope it helps....

 

Thanks