Hi all,
I am sure I am probably missing a ridiculously simple solution, but for the life of me I cant find it myself.
I have 10 cells which all contain a numeric value which is calculated based on vlookup formulas. I want to find the range between the lowest and highest numbers of these values, but when I use the simple =MAX(a1:a10), but the result I get is 0.
It appears the fact that these numbers are displayed as a result of the formula, means that the MAX and MIN functions are not dealing with numbers to produce a result but perhaps trying to apply this to formulas which doesnt make sense, hence the 0 value result.
Please can anyone shed any light on this for me. The values in A1:A10 will change in the future so have to take this into account.
Thanks in advance
Rob
Bookmarks