Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| Publish Date not found | ![]() 0 Views |
#shorts
We often need to compare 2 lists and extract the missing records in one of the lists.
I used the function:
=FILTER(A2:A26,ISNA(XMATCH(A2:A26,C2:C23)))
We often need to compare 2 lists and extract the missing records in one of the lists.
I used the function:
=FILTER(A2:A26,ISNA(XMATCH(A2:A26,C2:C23)))
Please take the opportunity to connect and share this video with your friends and family if you find it useful.