Excel: Compare text values in mutiple columns, and ignore cells


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 C D E F
Item 1 BE20 BE20 OK
Item 2 CZ28 BE20 Difference
Item 3 BE20 BE20 BE20 GB35 Difference
Item 4 CZ28 OK
Item 5 CZ28 CZ28 OK
Item 6 BE12 OK
Item 7 BE20 BE20 BE20 OK
Item 8 BE20 CZ28 CZ28 CZ28 Difference
Item 9 CZ28 CZ28 OK
Thanks in advance for any help/tips!


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 29, 2017.


For more resources for Microsoft Excel