Duplicate numbers

Occasional Visitor

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.


1 Reply


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: