I need to find the high, low and average of every data in every 7th column. I created a new sheet and used formulas to show the numbers but when I use max function etc, it doesn't recognise the numbers that are the answers to formulas. The cell in formatted as number. I need to find max, etc of the formula answer.
Solved by B. U. in 17 mins