Hello Members,
I have a requirement and I am not able to figure it out. using the formula Min(A1:A10) i am pulling out the minimum value / number from the range A1 to A10. Now, A1 to A10 have formulas. so instead of using Min(A1:A10), I want to use Min(formula of A1:formula of A10) to get the minimum value in that range. I am getting an error message #Value.
This I am trying so that I can eliminate the range A1:A10 physically and make use of the formulas. Hope I am clear on what I want. IF not I am truly sorry.
I have a requirement and I am not able to figure it out. using the formula Min(A1:A10) i am pulling out the minimum value / number from the range A1 to A10. Now, A1 to A10 have formulas. so instead of using Min(A1:A10), I want to use Min(formula of A1:formula of A10) to get the minimum value in that range. I am getting an error message #Value.
This I am trying so that I can eliminate the range A1:A10 physically and make use of the formulas. Hope I am clear on what I want. IF not I am truly sorry.