i want who is name is max often in column
i want who is name is max often in column
Try this array formula in J3, copied down.
=INDEX(B3:I3,MODE(MATCH(B3:I3,B3:I3,0)))
Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly braces yourself - it won't work...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Here, use this:
Formula:Please Login or Register to view this content.
Try this:
=INDEX($B3:$I3,MODE(MATCH($B3:$I3,$B3:$I3,0)))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Glenn Kennedy, does it need CSE?
Works for me with normal enter.
Well spotted.... my first (deliberate???) mistake of 2016...
how if =INDEX($E10:$L10;MODE(MATCH($E10:$L10;$E10:$L10;0))) not use CSE but only enter to calculation
It's the same.
answer is correct i am sorri
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks