Forum Discussion
Solved
Finding the low and high price of a part #
Hello - I am looking for some help with a spreadsheet I am working on. I have a sheet with a tab that has part#'s that have multiple purchases. There are a lot of the same part#'s on them. I hav...
- Thanks OliverScheurich. The Minifs/Maxifs worked great.
In cell C19 in the attached example:
=INDEX($E$2:$E$14,MATCH(A19&SMALL(IF($B$2:$B$14=A19,$A$2:$A$14),1),$B$2:$B$14&$A$2:$A$14,0),0)
In cell D19 in the attached example:
=LARGE(IF($B$2:$B$14=A19,$E$2:$E$14),1)
Maybe with the above formulas. Enter formulas as arrayformulas with ctrl+shift+enter if you don't work with Office365 or 2021. If you work with Excel 2019 or a newer version you might apply MAXIFS and MINIFS formulas.
Thanks OliverScheurich. The Minifs/Maxifs worked great.