vttrian
New Member
- Joined
- Feb 24, 2023
- Messages
- 7
- Office Version
- 2021
- Platform
- Windows
Say that I have products in column A (A1:A12) and prices in column B (B1:B12). I use the MIN and the XLOOKUP functions to see the most cheap product.
This is done with =XLOOKUP(MIN(B1:B12);B1:B12;A1:A12)
Let's say the function above returns A3 as the cheapest product.
In case the lowest price corresponds to 2 or 3 products though, the function will ignore them and return only the first one. (A3 product's price is 3$, but also A5 product's price is 3$).
Is there a way to run the MIN function again, in another cell, excluding the price (and therefore the product) that returned in the first run, by excluding the cell of column B from the range?
This is done with =XLOOKUP(MIN(B1:B12);B1:B12;A1:A12)
Let's say the function above returns A3 as the cheapest product.
In case the lowest price corresponds to 2 or 3 products though, the function will ignore them and return only the first one. (A3 product's price is 3$, but also A5 product's price is 3$).
Is there a way to run the MIN function again, in another cell, excluding the price (and therefore the product) that returned in the first run, by excluding the cell of column B from the range?