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?
try SMALL() or LARGE() and group the ranges inside of ()
eg =SMALL( (M8:M20; P8:P20; S8:S20; V8:V20) ; 2)
wont work as i need it to be in line as they are all different articles in column
i need to know within salesprice1 salesprice2, salesprice3 and 4 which is highest and second highest and same for lowest
i need to know within salesprice1 salesprice2, salesprice3 and 4 which is highest and second highest and same for lowest
- sorry I'm lost. what does "need it to be in line" mean? you want the highest and second highest for what then. you tried: MIN(M8;P8;S8;V8) then why not =SMALL( (M8; P8; S8; V8) ; 2) for second smallest?
- was too simple 😞 thank you
now how do i tell excel to look for biggest of the big prices and biggest of the small prices 😞 some kits have 4 prices and some only have 2
i guess i will need some if's