I have several stores. Data on stores is contained on different sheets. I need excel to look for the highest and lowest numbers and return that result to me.
AQuestionMark
Favorite Answer
Say the range to pick the highest number is in A1:A100 of Sheet1
Use this formula to get the highest number in range
=MAX(Sheet1!A1:A100)
Use this formula to get the lowest number in range
=MIN(Sheet1!A1:A100)
Alternatively, you can use LARGE and SMALL to achieve the same goal
Use this formula to get the highest number in range
=LARGE(Sheet1!A1:A100,1)
Use this formula to get the lowest number in range
=SMALL(Sheet1!A1:A100,1)