Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula help, PLEASE!!!
What formula do you use to look at a spread sheet and find the most frequently used number besides a MODE function. The problem I am haveing is I have used a MODE function to find the most frequent number, but now I need to find the second most used number and also the thrid and fourth most used numbers. But if I try and use a MODE function I do not know how to write it to not keep returning the most frequent number over and over???? Can ANYONE show me how to write a formula to not look for a value that has all ready been found in an array as the most frequent, I need to find the 5 most common numbers in an spreadsheet, bottom line... Thanks -- SRT ------------------------------------------------------------------------ SRT's Profile: http://www.excelforum.com/member.php...o&userid=25536 View this thread: http://www.excelforum.com/showthread...hreadid=389747 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |