Forum Discussion

HelpandImproveAP's avatar
HelpandImproveAP
Copper Contributor
Apr 17, 2022

Require a formula to automatically find the lowest figure of an information set

Hi,

 

I've got a data set that I'm working from on another tab - the data is a set of prices.

 

I need a formula to automatically bring up the lowest priced item within that data range in a certain cell.

 

Is this possible, and if so please can someone provide the formula?

 

Many thanks 

 

 

 

 

excel
Formulas and Functions

5 Replies

    • HelpandImproveAP's avatar
      HelpandImproveAP
      Copper Contributor
      Apr 18, 2022
      Much appreciated on your swift response.

      The formula works so very grateful for this.

      I do have an issue though and that issue is some of the data set contain £0.00. When I've used the SMALL function, it brings up the £0.00 figure but I don't want to include this. Is there any way to exclude specific cells or remove the ones with £0.00?

      Many thanks,
      A

Resources