Most valuable professional
  • Hot Topics

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 Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel