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

[HelpandImproveAP]

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 

[#2]

@HelpandImproveAP 

You may use SMALL function (microsoft.com)

[#3]

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

[#4]

@HelpandImproveAP 

Try this:

=SMALL(data_range,COUNTIF(data_range,0)+1)

[#5]

@HelpandImproveAP 

As variant

=AGGREGATE(15,6, 1/(range<>0)*range,1)

[#6]

@HelpandImproveAP 

=SMALL(IF(A1:A10>0,A1:A10),1)

An alternative could be above formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.