Feb 04 2021 12:15 PM
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.
Feb 04 2021 01:28 PM
@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)
