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:
- Microsoft Excel