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