Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

find entries common in two lists

Copper Contributor

how do you find entries common in two lists in excel 365?

 

3 Replies

@parky_pilot 

How to compare data in two columns to find duplicates in Excel

You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.  You will dind more information in the upper link.

 

NikolinoDE

For example, with the MATCH() function. Here is the syntax: =XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

@parky_pilot Find common entries, then what?

(1) Do you want to highlight commons?

(2) Do you want list separate common lists?

(3) Just want to mark TRUE/FALSE or Yes/No? or something else?

To highlight common items use-

=COUNTIFS($G$2:$G$7,$A2)>0

To separate lists, use-

=FILTER(A2:A7,COUNTIFS(G2:G7,A2:A7))

To mark as TRUE/FALSE, use-

=ISNUMBER(XMATCH(A2:A7,G2:G7,0))

Download the attached file to see more...

Harun24HR_0-1671288179507.png