Can someone please help provide a formula to comparing text values in multiple columns, for differences, and ignore blanks
For example below:
if the values (excluding blanks) in B,C,D,E match then F = "OK"
if the values (excluding blanks) in B,C,D,E do not match then F = "Diffrerence"
A
B...