Forum Discussion
Minumum value needs to be extracted from non-adjacent cells based on certain conditions.
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.
Sergei,
Along these same lines, how would you suggest I count the number of non adjacent cells in a row that contain the # character? I can't seem to get a countif sort of function to work and when I try to use the Find function I end up getting a value error as most cells do not contain it.
Thanks!