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 ano...
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")
Sergei, thanks again! I'll do some trials to make sure I understand how to do this most efficiently given the particular situation I'm working with and will be sure to comment further should things not go as planned.
Regards.
