Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare two columns

Status
Not open for further replies.

OCM

MIS
Joined
Sep 12, 2002
Messages
232
Location
US
Greetings,

I’m trying to compare two columns and list what is in one, but not in the other list (sample attached).

My template has 25 rows, if nothing is entered in columns A & B, I would like my formula to return blank.


TIA

Regards,


OCM
 
 https://files.engineering.com/getfile.aspx?folder=cf284046-a511-47d3-ad99-beb8fcbbbcd1&file=Compare_two_columns.zip
mintjulep,
Thank you for the resource link.
I applied the solution you provided and the formula worked nicely.
Code:
B - A (Only in B): =IF(NOT(IFNA(MATCH(B2,$A$2:$A$42,0),FALSE)),IF(B2,B2,""),"")

Regards,

OCM
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top