| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the most/least/average occurrence(appear) number?
Hi, I would like to find out what type of formula that I can use to find the least occurrence number in a column of numbers. As I know I can use =mode() to find out the most appear number (the number that come out the most) but I don’t know the formula for the least appear number and the average appearing number. Can someone help, thanks. -- cinoV ------------------------------------------------------------------------ cinoV's Profile: http://www.excelforum.com/member.php...o&userid=32016 View this thread: http://www.excelforum.com/showthread...hreadid=517639 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| finding the right number | Excel Worksheet Functions | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
| finding row number? | Excel Discussion (Misc queries) | |||
Threaded Mode
