I want to find the number having repeated time is max in the range which is limited by min and max number. So I try to develop a function but it can not run.
Help me pls,
Thank you so much
Please Login or Register to view this content.
I want to find the number having repeated time is max in the range which is limited by min and max number. So I try to develop a function but it can not run.
Help me pls,
Thank you so much
Please Login or Register to view this content.
Last edited by tamthat; 06-27-2018 at 01:35 AM.
anybody here?
help me pls. @@
If you just want 4(appears 17 that is max) as a result
=MODE(A2:E21)
You don't need a macro use conditional formatting
Last edited by Keebellah; 06-27-2018 at 04:40 AM.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
And then all without macros and conditional formatting
Thanks for help
I want to develop a function the same:and the result of the function will return the number having repeated time is max in new range which is limited by from a to b with a < b and a & b in Rng.Please Login or Register to view this content.
For example Rng in function from 1 to 10, and we have 100 elements in Rng, so I want to find the number having repeated time is max from 2 to 5 in Rng. And the function will be FINDX(2,5,Rng).
Thank you so much.
Last edited by tamthat; 06-27-2018 at 05:46 AM.
Then
=MODE(IF((A2:E21>=2)*(A2:E21<=5),A2:E21))
Confirm with Ctrl+Shift+Enter (Array Formula Entry)
If you want it as an UDF, this will return multiple value when Mode is multiple.
=ModeBetween(2,5,A2:E21)
Please Login or Register to view this content.
jindon, thank you so so much.
But I want to return THE NUMBER having x above your function. Thank you again
Last edited by tamthat; 06-27-2018 at 11:11 AM.
You are welcome and thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Yes, thank you, but I have just check again, can you help me more about your function? I want to return THE NUMBER refer x in your function (THE NUMBER is element of rng, not return MAX value).
In =ModeBetween(2,5,A2:E21), I want to return 4, not 17. Thank you so much
Last edited by tamthat; 06-27-2018 at 11:11 AM.
1)
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding
For normal conversational replies, try using the QUICK REPLY box below.
2) Right, change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
jindon, that's great. Thank you again.
Last edited by tamthat; 06-27-2018 at 11:10 AM.
tamthat
The forum doesn't like the full quote of the post.
So, edit your posts and remove them.
yes, of course. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks