View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SRT SRT is offline
external usenet poster
 
Posts: 1
Default MODE spreadsheet help


I am tring to do several MODE functions on a spreadsheet.
have done the first set of MODE functions for the sheet, what I am no
tring to do is run another MODE function that returns the next mos
frequent number to appear on the sheet. I can not figure out how t
write the MODE function to not look at the most frequent value bu
rather look at the second most frequent and the third, fourth and s
on... Can anyone PLEASE help with this??????

--
SR
-----------------------------------------------------------------------
SRT's Profile: http://www.excelforum.com/member.php...fo&userid=2553
View this thread: http://www.excelforum.com/showthread.php?threadid=38973