Count and Occurrence of Duplicates in a Column
I'm trying to count the number of duplicates in a column and then number those duplicates in another column.
I'm using the formula COUNTIF([Legacy ID]:[Legacy ID], [Legacy ID]@row) in the Multiples column to count the number of duplicates in the Legacy ID column. I need help with a formula to create the MCount column.
Thanks for your help!