multiple mode function

**cihow81** · 07-28-2009, 11:55 PM

Hi all,

Does EXCEL have the function for Multiple Mode?

Ex.: 97, 98, 99, 99, 100, 100, 101, 102

The mode is 99 and 100 but EXCEL only returns 99. Is there any way to display mutliple modes in EXCEL?

**windknife** · 07-29-2009, 12:05 AM

Use the following UDF.

Please Login or Register  to view this content.

You can use following step to add this function.
1. Open up a new workbook.
2. Get into VBA (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste the Excel user defined function examples -
5. Get out of VBA (Press Alt+Q)

Example usage: =moder(A1:A100)

Hope this helps,
WindKnife