I am looking for a result like as mentioned below. What formula then I should write in the RESULT column?
| Heading1 | Heading2 | Heading3 | Heading4 | RESULT |
| 4 | 3 | 4 | FALSE | |
| 0 | 1 | 1 | 1 | TRUE |
| 5 | 5 | 4 | FALSE | |
| 5 | 5 | 5 | 5 | TRUE |
| 7 | 7 | 7 | TRUE | |
| 5 | 5 | 4 | 0 | FALSE |
| 5 | 0 | 5 | 5 | TRUE |
| 5 | 5 | TRUE |
Hi,
Please try this one. If the count of the biggest number in range A2:D2 equals to the number of numbers greater than 0, the formula returns TRUE which means all non-zero number are the same with the biggest number.
Clark
clark shao said
Hi,Please try this one. If the count of the biggest number in range A2:D2 equals to the number of numbers greater than 0, the formula returns TRUE which means all non-zero number are the same with the biggest number.
Clark
Thank you Clark. It's so simple yet awesome! Don't know how to say 'thank', but will try to help others in this forum.
amisandip said
Thank you Clark. It's so simple yet awesome! Don't know how to say 'thank', but will try to help others in this forum.
I'm very glad to be able to help ：）
There are more interesting functions for your reference 🙂
