list of duplicates

[Renee Schweke]

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]

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

[#3]

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