Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the least frequent value in an array
Hi,
Does anyone know if Excel (either 2000, 2003, XP or 2007) has a quick way of finding the OPPOSITE of the mode, I.E. the least frequently occuring value in an array of values? I've thought of count and countif possibilities, but for what I want to set up and who is going to use it that will be too complex. I need to set up a sheet that will receive about 50 new sets of data per day and each time it is updated we need to calculate, amongst about 40 other things, the mode and the least frequent value from one of the data sets. Mode is hunky dory......can anyone help with the other please? Thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Data in an Array | Excel Worksheet Functions | |||
finding nearest match from an array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
Finding the most frequent occurances | Excel Discussion (Misc queries) |