LinkBack URL
About LinkBacks
Which formula do i use to return a name to me, that is the most occurring from a list?
i tried =mode(range) but i dont think it was the right one.
i tried =mode(range) but i dont think it was the right one.
Last edited by Nathaniel82; 07-17-2009 at 10:02 AM. Reason: Moderator made me.
deleted op hasn't changed title
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I did change the title.
Not sure what you want me to change the title to.
will try a different forum.
you have now ,not when i posted tho' answer is
=INDEX(A1:A100,MATCH(MAX(COUNTIF(A1:A100,A1:A100)),COUNTIF(A1:A100,A1:A100),0))
array entered see my sig. for how to enter arrays
bye byewill try a different forum
doesn't work anyway. like i said, it's a name i want not a number
thanks.
Martin's formula works.. you need to confirm it with CTRL+SHIFT+ENTER... please try it before giving up.
All we ask is that you read and follow the forum rules. This in return for free advice and help.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Works fine for me, are you sure you have entered it as an array?
Oops, someone said it before me, must type quicker. Lol
Last edited by Andrew-Mark; 07-17-2009 at 10:43 AM. Reason: Too slow :(
You could also use this formula
=INDEX(A1:A100,MODE(IF(A1:A100<>"",MATCH(A1:A100,A1:A100,0))))
confirmed with CTRL+SHIFT+ENTER
like MODE it returns N/A if there are no repeated values in the range
Okay guys. This formula worked but how do i edit it so that it gives me the 2nd, 3rd, etc...most repeated names? So that i can create a top 5?
Thanks in advance guys.
You need to start your own thread.
See forum rule #2:
http://www.excelforum.com/forum-rule...rum-rules.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
ha ha ha, sorry for my petulence. it's working now.
thanks to all who helped and all who told me off.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks