Forum Discussion
Minumum value needs to be extracted from non-adjacent cells based on certain conditions.
I'm trying to extract the minimum value from a number of cells that aren't adjacent to each other such that I'm able to exclude any particular value with something simple like an entered value in another cell but can't figure out how to get this to work...
For example, cell A1 has a contractor 1's name, cell B1 has 1's price, cell D1 has contractor 2's name and cell E1 has 2's price and so on for about 10 different contractors. I need to extract the minimum price while being able to exclude any of the prices if I think it is suspect.
I looked into MINIFS but it looks like it can only be used with adjacent cells.
11 Replies
Hi Robert,
If you mean to find min on B1,D1,F1 you may apply MIN or MINIFS to A1:F1 - they will ignore the cells with the text.
That's very helpful Sergei, thanks! The harder part is to have certain cells non considered if the cell prior contains a value - X, for example. I need to be able to exclude the bids from certain contractors if I think their number is suspect without deleting the number....
You may shift min range and criteria range on one cell, like
=MINIFS(B1:F1,A1:E1,"<>X")
