find the maximum number of appearances in a range

a7n9

Well-known Member
Joined
Sep 15, 2004
Messages
696
Hello all,

I've rows with some numbers in it. like this
Book2
ABCDEFGHIJKLMNOPQRST
1S1S2S3S4S5S6S7S8S9S10S11S12S13S14S15S16S17S18S19S20
21515748180413515710141411115148
31101830316912101718810154211
418159160810868614521802
5174511140716111361718981531679
Sheet1


I want to find which number has made the maximum number of appearances for each row. For the first row 15 has appeared 4 times.

Thanks for your help.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

a7n9

Well-known Member
Joined
Sep 15, 2004
Messages
696
Haha... I forgot it's called as "Mode"..thanks anyway.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,816
Messages
5,638,496
Members
417,029
Latest member
lingx86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top