Forum Discussion
Solved
has to be a way for finding first and second highest price in 4 seperate columns
Prix de vente1 Batteries2 Prix2 Prix de vente2 Batteries3 Prix3 Prix de vente3 Batteries4 Prix4 Prix de vente4 36,99 $ N6-4.5T1 17,56 $ 23,99 $ 46,99 $ NP...
- thank you for the sample sheet. that makes things much easier.
So you want "highest sales price of YUASA and highest sales price of Nitro" but is that per row or for all rows and what about 2nd highest and 2nd lowest?
This may look somewhat alien; it is a 365 solution.
MinPriceλ
= LAMBDA(k,
LAMBDA(record,
SMALL(CHOOSECOLS(record, 1, 4, 7, 10), k)
)
)
WorksheetFormula
= HSTACK(
BYROW(SalesTable,MinPriceλ(1)),
BYROW(SalesTable,MinPriceλ(2))
)and don't forget it also requires Beta function
but I don't know if that does what they want as I still don't know what they want.
but I don't know if that does what they want as I still don't know what they want.