Forum Discussion
HelpandImproveAP
Apr 17, 2022Copper Contributor
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...
SergeiBaklan
Apr 17, 2022Diamond Contributor
You may use SMALL function (microsoft.com)
HelpandImproveAP
Apr 17, 2022Copper Contributor
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
- OliverScheurichApr 18, 2022Gold Contributor
=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.
- SergeiBaklanApr 18, 2022Diamond Contributor
- Riny_van_EekelenApr 17, 2022Platinum Contributor