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?
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.
You are correct. I could have, and should have, written a version with INDEX/SEQENCE.
I was more focussed on the fact that the formula would not allow me to provide k={1,2} in the SMALL function. I reckon that about 80% of my array solutions require 'nested arrays' or 'arrays of ranges' and about the same proportion of my time is spent looking for workarounds!
REDUCE and HSTACK works, MAKEARRAY and Thunks work but are overly CPU intensive. MID expands an array of fixed-length strings to an array of arrays, but I resent having to scratch around for solutions that Excel should provide by default. All that to maintain compatibility with obsolete versions of Excel that I was happy to place on the bonfire.