Hi all
I am trying to return the mode average for sales prices.
I am analysing pricing and want to work out what the most popular unit price we give is for each item.
I can pull the min, the max and I have managed to calculate the mean average, but at the moment the highest and lowest values are throwing this out a bit, so I'd like the mode.
Is there a way to get the most frequently occurring value some how?
There is a MODE function in excel but I don't know if it is possible to incorporate this?
