Apr 17 2022 11:09 AM
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
Apr 17 2022 11:23 AM
You may use SMALL function (microsoft.com)
Apr 17 2022 05:00 PM
Apr 17 2022 10:36 PM
Apr 18 2022 01:42 AM
Apr 18 2022 01:46 AM
=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.