MODE spreadsheet help
:confused: 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 |
MODE spreadsheet help
The MODE function returns the most common value in the data set. I don't
believe there is an option using MODE to get what you want. "SRT" wrote in message ... :confused: I am tring to do several MODE functions on a spreadsheet. I have done the first set of MODE functions for the sheet, what I am now tring to do is run another MODE function that returns the next most frequent number to appear on the sheet. I can not figure out how to write the MODE function to not look at the most frequent value but rather look at the second most frequent and the third, fourth and so on... Can anyone PLEASE help with this??????? -- SRT ------------------------------------------------------------------------ SRT's Profile: http://www.excelforum.com/member.php...o&userid=25536 View this thread: http://www.excelforum.com/showthread...hreadid=389731 |
All times are GMT +1. The time now is 08:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com