Forum Discussion
Duplicate numbers
Can someone tell me how to show duplicate numbers in a column on a spreadsheet. I have a row of about 200 numbers and I want to know what the most duplicated numbers are in that row.
You can use Conditional Formatting > Highlight Cells Rules > Duplicates to highlight duplicate values in a range.
You can use the MODE function to return the most frequently occurring value in a range of numbers:
=MODE(A1:A200)