Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

list of duplicates

Copper 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