An alternative method I use are, filter, vlookup on both lists on each other and conditional formatting for highlighting duplicates
2025-07-16 18:57:39
13
Whyuwannac :
What about the opposite?
2025-07-16 00:12:43
2
Ed :
Do you have a YouTube channel? If not you should make one
2025-09-12 02:20:13
0
user3763605173805 :
Does it matter which list you choose as the array?
2025-07-18 21:00:09
0
McOraz :
so it's safe to say list 1 is a subset of list 2. yes?
2025-08-08 11:38:29
0
vinnymoon58 :
Can you explain how it would work the same way?
2025-07-16 08:25:06
0
AnRa Productions :
any way to remove the copilot button?
2025-07-16 00:41:59
0
Edward Tatta :
I’ve always wondered, instances where you have very large datasets where dragging the mouse for the entire column is not feasible, what is the best way to do this same task and grab an entire column?
2025-07-31 02:47:59
0
miá :
How can I filter f that are not in the same column?
2025-07-16 17:12:56
1
Farhan :
great, can you do the opposite too?
2025-07-24 08:37:21
2
𝒜𝒷𝑜𝑜𝒹 :
What if the name format is different in another sheet?
2025-07-16 21:29:30
1
Alx Tlz :
This is great!
2025-08-04 15:09:14
1
Romz :
I needed this today and yesterday😩😩
2025-07-17 16:11:41
1
Whalleed Ebrahim :
Great stuff. very helpful. you are.doing amazing work. please.help - how do I compare two data sets and combine into 1 dataset without duplication?
2025-07-17 12:21:31
0
__Just Random🌸🎀💝 :
I think you can line these list in one column then just use the conditional formatting for duplicates.
2025-07-18 16:45:19
0
Kika :
I’d just use the conditional formatting to highlight the duplicates
2025-08-23 19:29:05
1
bgdefxt :
how about for more than 2 lists
2025-07-16 06:18:03
0
officetips :
thanks
2025-08-03 15:33:24
1
nelsonoguntade :
thank youuu....been looking for how to do this
2025-07-17 05:35:25
1
DJ :
This does it in 9 seconds highlight both columns
2025-09-10 20:11:53
0
Gold_I :
Same for multiple lists ?
2025-07-17 18:30:51
0
user8915099111445 :
What if you want to compare names from 2 different excel sheets?
2025-11-24 14:09:36
0
user6543532326478 :
What about if you want same value which one is - ve and other is +ve
2025-07-16 16:30:58
0
walidhjjm :
@Excel With Kyle is there a way to do the opposite? Meaning I want you to compare two lists and find out which name is missing from the main list I’m comparing against. Thanks Kyle!
2025-07-20 23:59:17
0
JustJeanne :
❤️❤️❤️
2025-07-23 12:00:32
0
To see more videos from user @excel_with_kyle, please go to the Tikwm
homepage.