Help me develop function to find the number having repeated time is max...

[tamthat]

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.

[tamthat]

anybody here?
help me pls. @@

[jindon]

If you just want 4(appears 17 that is max) as a result

=MODE(A2:E21)

[Keebellah]

You don't need a macro use conditional formatting

[Keebellah]

And then all without macros and conditional formatting

[tamthat]

Thanks for help
I want to develop a function the same:

Please Login or Register  to view this content.

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.
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.

[jindon]

Then
=MODE(IF((A2:E21>=2)*(A2:E21<=5),A2:E21))
Confirm with Ctrl+Shift+Enter (Array Formula Entry)

[tamthat]

Then
=MODE(IF((A2:E21>=2)*(A2:E21<=5),A2:E21))
Confirm with Ctrl+Shift+Enter (Array Formula Entry)

Thank you so much

[jindon]

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.

[tamthat]

jindon, thank you so so much.
But I want to return THE NUMBER having x above your function. Thank you again

[jindon]

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.

[tamthat]

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

[jindon]

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

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[tamthat]

jindon, that's great. Thank you again.

[jindon]

tamthat

The forum doesn't like the full quote of the post.
So, edit your posts and remove them.

[tamthat]

yes, of course. thanks