Macro needed to show 3 most frequently numbers apearing

[ricklou]

Good day

I wonder if someone can help me I have 5 columns with a number in it. I want a macro that will calculate the most occurring 3 numbers out of 5nrs(from left to right) -t must count how many times it appeared.

I want to know (example only)

Nr 2 6 8 -occurred 15 times
Nr 5 9 2 - occurred 8 times

So basically the macro must count only the 3 most occurring numbers that appear going down from left to right.

This will be highly appreciated as I have over 50 000 records and will save allot of time

Rep given for solution

Many thanks

Ricklou

Sample attached

[mikeTRON]

Could you use a pivot table and a count field?

[ricklou]

Could you use a pivot table and a count field?

Yes or macro........I am just not good in excel got no idea how to do it -keep in mind 3 out of 5 that apear the most must be counted.

Thanks Mike

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[ricklou]

Try this:-

Please Login or Register  to view this content.

Regards Mick

Mick thank you very much I dont know if i did something wrong it says "compile error expected end with"

Am I doing something wrong ? Thanks

[MickG]

Sorry I left the last line of the code off when I copied it:-
Try this:-

Please Login or Register  to view this content.

Regards Mick

[ricklou]

Sorry I left the last line of the code off when I copied it:-
Try this:-

Please Login or Register  to view this content.

Regards Mick

Mick excellent coding Sir well done!!!! seems like it work but may I ask you will it list the nrs that's second most third most .....etc or will this only list the most appeared ? Can u clarify and thank you so much once again

[MickG]

Try this:-
Gives 1 to 6 largest
Results start "K1"

Please Login or Register  to view this content.

Regards Mick

[ricklou]

Try this:-
Gives 1 to 6 largest
Results start "K1"

Please Login or Register  to view this content.

Regards Mick

Fantastic coding - works flawlessly!!!!!!!!!!!! Thank you so very much -Rep GIVEN!!!!

Solved by Mick thanks

[MickG]

You're welcome