Forum Discussion
Minumum value needs to be extracted from non-adjacent cells based on certain conditions.
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!
Hi Robert,
Afraid I didn't catch. Do you mean # is the cell value like here
or # is the part of the string in the cell, or what? Small sample will help, thank you.