Reply to thread

Message: [QUOTE="Susan, post: 14201378"] Excel 2003/2013 Win XP/7 (using 2 different computers - needs to work on both) I have a range of unsorted data consisting of a row. =MAX(E16:BB16) gives me the highest value =AVERAGE(E16:BB16) gives me the average value =MIN(E16:BB16) gives me the lowest value How do I get the value of the range between the maximum and the average? And the value between the average and the minimum? Can I do it with one formula - perhaps an array formula? - or do I need to use helper cells? This is for my personal use, so I don't mind using helper cells. Ultimately I want a range that looks like this: Highest value know how Middle-High value Middle value know how Middle-Low value Lowest value know how Any thoughts would be greatly appreciated. :) Susan [/QUOTE]