On the sheet there are many rows. There are five columns in each row. But in these columns some cells are blank. I want to get formula for all the rows that will bring minimum value for each row, provided at least three cells are non-blank in that row. If less than three values are available in a row then the formula shall not apply for that row. That is minimum value for a row containing less than three non-blanks cells shall not be highlighted.
EXAMPLE
EXAMPLE
A | B | C | D | E | |
1 | 10 | 20 | 46 | 55 | 58 |
2 | 15 | 46 | 22 | 66 | 18 |
3 | 34 | 56 | |||
4 | 23 | 56 | 78 | ||
5 | 59 | 46 |