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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,212,058
Messages
6,105,654
Members
447,974
Latest member
misspancake

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
Back
Top