BRIEBRIE123
New Member
 Joined
 Dec 30, 2021
 Messages
 4
 Office Version

 2016
 Platform

 Windows
Hi there,
Piggybacking off a previous thread I found in this forum, I used the following formula to return "Yes" if all cells in my column were either blank, or were the same:
=IF(COUNTIFS(C14:C40,"<>"&"",C14:C40,"<>"&"C14"),"No","Yes")
I am trying to use this formula for another similar second column, however I can't get it to work properly (it does not return "Yes" if all values are the same". The only difference between the two columns is that the first one i used it for included 1) cells with values and 2) blank cells. The second, however, includes both 1) columns with values (formuladriven) and 2) columns that are blank as a result of an =IFERROR(...,"") formula which results in a "blank cell".
I was just wondering if there was a reason as to why the =IF(COUNTIFS() formula is not working with the second formuladriven column? I assumed it would work, as I included an IFERROR statement that transforms #N/As into blank cells? I can't seem to figure out why!
Piggybacking off a previous thread I found in this forum, I used the following formula to return "Yes" if all cells in my column were either blank, or were the same:
=IF(COUNTIFS(C14:C40,"<>"&"",C14:C40,"<>"&"C14"),"No","Yes")
I am trying to use this formula for another similar second column, however I can't get it to work properly (it does not return "Yes" if all values are the same". The only difference between the two columns is that the first one i used it for included 1) cells with values and 2) blank cells. The second, however, includes both 1) columns with values (formuladriven) and 2) columns that are blank as a result of an =IFERROR(...,"") formula which results in a "blank cell".
I was just wondering if there was a reason as to why the =IF(COUNTIFS() formula is not working with the second formuladriven column? I assumed it would work, as I included an IFERROR statement that transforms #N/As into blank cells? I can't seem to figure out why!