Hi, I need a formula to compare 2 tables with header "model"
ability to include or exclude data when compare.
I have tried this but unsuccessfully. if anyone can help, with other tools that will be great too. thanks in advance
=COUNTIF(Table2[Model],[Model])=1
Data 1
Model QTY Location
4548549 EA 90011
544873 EA 90650
547907 EA 91331
547297 EA 94565
549177 EA 90044
549303 EA 92336
724543 EA 92335
73177 EA 90805
745424 EA 90250
75454254 EA 90201
77182 EA 90280
791754 EA 91342
7954547 EA 92683
70297 EA 90011
711543 EA 90650
730549 EA 91331
745428 EA 94565
814854 EA 90044
825404 EA 92336
84834 EA 92335
854108 EA 90805
Data 2
Model
54863
56906
547907
745424
69175
85540
62453
Bookmarks