@excel_with_kyle: How to find common values between 2 lists in Excel! #exceltips #data #exceltricks #exceltutorial

Excel With Kyle
Excel With Kyle
Open In TikTok:
Region: US
Tuesday 15 July 2025 23:30:00 GMT
48671
2029
51
242

Music

Download

Comments

drmagic2
Avishek :
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
minaday08
Whyuwannac :
What about the opposite?
2025-07-16 00:12:43
2
engineered91
Ed :
Do you have a YouTube channel? If not you should make one
2025-09-12 02:20:13
0
user3763605173805
user3763605173805 :
Does it matter which list you choose as the array?
2025-07-18 21:00:09
0
mcoraz3
McOraz :
so it's safe to say list 1 is a subset of list 2. yes?
2025-08-08 11:38:29
0
vinnymoon58
vinnymoon58 :
Can you explain how it would work the same way?
2025-07-16 08:25:06
0
anubis20188
AnRa Productions :
any way to remove the copilot button?
2025-07-16 00:41:59
0
edward_tatta
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
miafreepalestine0
miá :
How can I filter f that are not in the same column?
2025-07-16 17:12:56
1
fhassan77
Farhan :
great, can you do the opposite too?
2025-07-24 08:37:21
2
aboodtariq_95
𝒜𝒷𝑜𝑜𝒹 :
What if the name format is different in another sheet?
2025-07-16 21:29:30
1
alxtlz
Alx Tlz :
This is great!
2025-08-04 15:09:14
1
romeolosaba
Romz :
I needed this today and yesterday😩😩
2025-07-17 16:11:41
1
mwe0076
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
__justrand0m
__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_mikaze
Kika :
I’d just use the conditional formatting to highlight the duplicates
2025-08-23 19:29:05
1
gebles2vw
bgdefxt :
how about for more than 2 lists
2025-07-16 06:18:03
0
officetips68
officetips :
thanks
2025-08-03 15:33:24
1
nelsonoguntade
nelsonoguntade :
thank youuu....been looking for how to do this
2025-07-17 05:35:25
1
rodnin2
DJ :
This does it in 9 seconds highlight both columns
2025-09-10 20:11:53
0
gold_i93
Gold_I :
Same for multiple lists ?
2025-07-17 18:30:51
0
wilson_stop_it
user8915099111445 :
What if you want to compare names from 2 different excel sheets?
2025-11-24 14:09:36
0
user6543532326478
user6543532326478 :
What about if you want same value which one is - ve and other is +ve
2025-07-16 16:30:58
0
walidhjjm
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
genienojeanne
JustJeanne :
❤️❤️❤️
2025-07-23 12:00:32
0
To see more videos from user @excel_with_kyle, please go to the Tikwm homepage.

Other Videos


About