Forum Discussion
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 certa...
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
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
=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.
