Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,919 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I need the Column J result:
Try entering a formula to J1 cell:
ā=IF(COUNTIF(A1:G1,I1)>0,"Match","Not Match")
If it works, then copy it to other cells of J.