Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

I need excel to compare numbers on different sheets and then return the highest and lowest values.?

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.

1 Answer

Relevance
  • 1 decade ago
    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)

Still have questions? Get your answers by asking now.