I am using the following formula to compare values in cells:
=AND(EXACT(F18:H18,F18))
Column F will always have a value.
I would like to modify my formula so that if there is a blank cells in columns F to H then this is ignored when doing the comparison. So, if F has CAT, G has CAT, but H has blank, the result will still be true.
Many thanks.
=AND(EXACT(F18:H18,F18))
Column F will always have a value.
I would like to modify my formula so that if there is a blank cells in columns F to H then this is ignored when doing the comparison. So, if F has CAT, G has CAT, but H has blank, the result will still be true.
Many thanks.