Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Using the mode function

I have a group of numbers that I am trying to find the the mode of using the
mode function. When I have multiple mode i.e 200 shows twice and 201 shows
twice the standard function returns the lower of the two modes and I want it
to return the higher of the two modes. Is there anyone who can help me figure
this out.
--
Detra (Thanks)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	1	March 11th 07 10:38 AM
Mkae Mode function return "" instead of #N/A when there is no Mode	Tonso	Excel Discussion (Misc queries)	2	March 10th 07 05:10 PM
MODE Function	cesar	Excel Worksheet Functions	1	January 4th 07 10:47 PM
MODE Function	Anita	Excel Worksheet Functions	5	December 12th 05 04:28 PM
MODE function	Dobbie22	Excel Worksheet Functions	2	December 10th 04 04:13 PM

All times are GMT +1. The time now is 10:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us