list of duplicates

Question

What formula can&nbsp;display duplicate rows on a spreadsheet as a list with all the row numbers?&nbsp;The range would be A1:F462256.&nbsp; It's a big list.&nbsp; I don't want to highlight the duplicates.&nbsp; I want to have a separate list that tells me all the duplicates so they can be fixed after the duplicates are filtered out.&nbsp;Thank you in advance!&nbsp;

jkpieterse · Answer

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

ashakantasharma · Answer

You can use COUNTIF Formula to know how many number of times a value is being repeated in a row.&nbsp;&nbsp;=Countif(A:A, A1)&nbsp;Hope it helps....&nbsp;Thanks

Forum Discussion

list of duplicates