how to calculate the mode

[jakeembx]

Hi, does anyone know how to code a function that will calculate the mode of 6 numbers?? thank you!

[Olly]

Try:

Please Login or Register  to view this content.

Amend range reference as necessary.

In vba you can simply use worksheetfunction.mode.

[jakeembx]

thank you, how would you set "worksheetfunction.mode" to a particular range??

[Olly]

For example:

Please Login or Register  to view this content.

How are you wanting to use it?

[jakeembx]

to calculate the mode of 6 cells in vba

[Olly]

to calculate the mode of 6 cells in vba

Okay. Hope this helps, then. Hard to be more specific....

[jakeembx]

thanks for your help!