abacon1960
Board Regular
- Joined
- Jul 28, 2014
- Messages
- 54
I am using a MIN function to determine my lowest Subcontractor Bid. =MIN(R86,U86,Z86,AC86,AF86,AI86) I have six columns for 6 subs. Herein lies the problem. I only have three subs bidding so the MIN is picking up the first zero columns as Low Sub with zero dollars. Is there a way to do this without revising the MIN function to take out the three cells I do not need.