How to Find Duplicates in Excel & Highlight Duplicates If You Need To

How about MsAccess 🙂

This is useful. Too bad it's not in google sheets. I need similar formulas for google sheets.

That ConCat formula is a game changer. THANK YOU

The content is good; but you are speaking too fast like AI Machine. Please talk like Human Being; because your followers are human not a machine. We know you are expert. Hence, you have to learn the pedagogy of how to teach.

Love it super easy!!! Do you have classes?

is there a way to look sum duplicates in a formula? in column a is a list of locations, and column b is sale $ers. how do i create a list of only locations that are duplicated and sum their sales figures?

Making ctr T table n remove duplicate can work?

I am not able to Use the concat function for generating unique key, Instead it is combining all the details in one cell

fantastic video, straight to the point. thank you very much
Highlight column(s)/cell(s), click Home at the top > Conditional Formatting > Highlight Rules > Duplicate Values

Hi Leila, is there a way to do this in Power BI? To return a table that shows duplicates?

Thanks!

thanks a lot, u saved my life (Y)

you go to fast, you do not realize that student has to listen follow and absorb which takes much time. If you want to be a appreciated then go slow.

Nice video

Great and really helpful and did my work
thanks for video

Excellent guidance and this will help me so much in my work as I've to clean up ~21k rows of data. Thanks Leila.

I purchased same products with multie quantities on different dates with different prices, how can i get the price when the first was purchased and its quantity is still remained i would like to have the same price on general entry if still its quantity is available and if the quantity is finished of first purchased then i want the second price of same product based on its stock qty available.

I had trouble with the formulas countif, sumif, duplicates.

HI I HAD ONE SHEET FOR DIFFERENT INVOICE AND SOME INVOICES HAVE MULTIPLE LINE ITEMS SO HAVE MORE THEN ONE ROW TO THAT PARTICULAR INVOICE NOW I WANT TO ASSIGN AUTO SERIAL NUMBER TO THEM WHAT IS THE SHORT CUT OR EASY WAY TO THAT .. LOOKING FORWARD TO HAVE YOUR RESPONSE SOON

How do you remove the duplicates and save properly so they don’t repopulate the duplicates when the new information has generated?? Please help🙏🏽

Super helpful! Thank you!

Can anyone tell me
How to Remove Dupilcate Values in Single Cell
No VBA code pls

Hi how do I allow duplicates in a column with the following conditions?
Eg. Phone 1 is in column G but when phone 1 is returned it will be in column R.
Allow duplicates to happen in column G only when column R has that phone 1 returned?

Hi... While using filter function, if there is blanks how to avoid them

Great video, very recommended!

OMG you are ALWAYS the best!!! Thank you!!!

Perfect

Hello, Are you using apple laptop via xlsx? Cause i cannot find duplicate values? Please help

can anyone clear my below doubt?
How can I highlight the duplicate numbers in different colors in one column?
If the duplicate number is between 1 to 10 different color
If the duplicate number is between 11-20 different color
If the duplicate number is between 21-30 different color
If the duplicate number is between 31-40 different color
If the duplicate number is between 41-50 different color

What is the formula for that?

I love to use conditional formatting. Thats what I teach beginners at work

Thanks

Nice work. This might be helpful. I used to get very odd behaviour using COUNTIF embedded in a lambda function that was called from within another LAMBDA (something to do with it not accepting the variable which although was a vector, was strictly not a RANGE, which it must take as its first argument). It did my head in! This formula avoids using COUNTIF, and IMO is more robust (when doing complex and nested lambdas) . Hope its useful

COLUMN_DUPLICATES = LAMBDA(col_vector,

LET(
count, SCAN(0, col_vector, LAMBDA(a, r, SUM(--(r = col_vector)))),
duplicates, IF(
IFERROR(ROWS(UNIQUE(FILTER(col_vector, count > 1))), 0) = 0,
"No Duplicates",
UNIQUE(FILTER(col_vector, count > 1))
),
duplicates
)
);

Is there a way to add a custom emoji to excel? I find the existing excel emojis very plain and somewhat boring.

Thanks Leila. Many of us deal with duplicate data on daily basis. This video is a boon.

Good video! Your tips are a great way to keep me updated with excel. Thanks for sharing.

Very Nice and practical.😀

Valuable video, very useful.

Thank you Leila. You are great.

How do you unhighlight them? Can't yse undo coz I already saved it.

Thank you, Leila

Pivot Table

I can't get this to work with dates?

I needed this

Why is this video 8 minutes long?

Hi Leila, I hope you see this comment. I just want to ask if there's a way to highlight the duplicates in alternative colors so that I won't do it manually?

Great, many many thanks

Very useful..learnt something new... 👍

How to find duplicates of the same item serial numbers showing in different tabs of the Excel file.

Leila, if you could some how find a way to dub your videos to Spanish, your channel would double in size overnight.