Compare Two Lists

Compare Two Lists

HomeOther ContentCompare Two Lists
ChannelPublish DateThumbnail & View CountActions
Channel AvatarPublish Date not found Thumbnail
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)))

Please take the opportunity to connect and share this video with your friends and family if you find it useful.