Excel – compare two or more columns

=IF(AND(B78=P78;C78=Q78;D78=R78;E78=S78;F78=T78);"DA";"NE")

… and dragg…

https://www.ablebits.com/office-addins-blog/2015/08/26/excel-compare-two-columns-matches-differences/

https://support.microsoft.com/en-us/office/using-if-with-and-or-and-not-functions-d895f58c-b36c-419e-b1f2-5c193a236d97?ui=en-us&rs=en-us&ad=us

This entry was posted on Tuesday, June 16th, 2020 at 5:45 pm. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.