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

@morgan12JS 

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)