View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Detra E. Detra E. is offline
external usenet poster
 
Posts: 1
Default 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)