Forum Discussion
Slyfox6915
Jul 25, 2022Copper Contributor
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...
- Jul 25, 2022thank 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?
Slyfox6915
Jul 25, 2022Copper Contributor
here is an example
mtarler
Jul 25, 2022Silver Contributor
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?
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?
- Slyfox6915Jul 26, 2022Copper Contributori just need highest of each brand not second highest
- mtarlerJul 26, 2022Silver Contributor