Forum Discussion
Formula help - multiple cells matching and returning an output whilst ignoring blanks
Hi there I am looking for some help. I want to compare four cells on the same row to see if any combination of them do not have the same text, and then output either yes or no. I have tried a cou...
=IF(OR(SUM((H1<>"")+(K1<>"")+(N1<>"")+(Q1<>""))=0,SUM((H1<>"")+(K1<>"")+(N1<>"")+(Q1<>""))=SUM((H1=K1)+(H1=N1)+(H1=Q1))+1),"Same","Different")
If you don't have Microsoft 365 or Office 2021, confirm with Ctrl+Shift+Enter.