Count duplicate values in excel | Using Formulas

[@noemymauricio7839]

Ive been 2 hours watching the same thing in anothers channels for a school project and i coudnt do it. Thanks with your video i did it in less than 4min.

[@ExcelTipsVideos]

Glad that this was helpful

[@aymanmohamed221]

Thank you brother Very informative

[@sarahahenkanboateng1792]

Thank you so much. This really has solved all my duplicates wahala. You are forever be blessed

[@ExcelTipsVideos]

Glad that it helped

[@sourabhmayekar3354]

Thank you. This saved me so much time

[@ExcelTipsVideos]

You're welcome!

[@kimberlysvasquez6238]

Thank you! You saved me so much time :)

[@simonblunden2151]

Brilliant. This totally helped me out! THank you.

[@jamesbates342]

Great video. Thank you for sharing.

[@ExcelTipsVideos]

glad that it helped

[@lakshmisai8799]

Thank you very much for the great video, did my work very easily🤝

[@ExcelTipsVideos]

Glad it helped

[@chaudhryjunaidashraf2548]

Great To Watch, Thanks For Making

[@ExcelTipsVideos]

Glad that it was helpful

[@alexanderclarke2508]

Awesome video thank you 👍🏻

[@edwarddizengoff8414]

Thank you so much this was very helpful and saved me so much time!

[@ExcelTipsVideos]

Glad it helped!

[@sunderpreetsaini]

VERY EASY WAY OF EXPLAINING.VERY INTERSTING.

[@ExcelTipsVideos]

Thanks for liking

[@yashshriwas4253]

Very very thanks to you ,it's a very valuable video

[@ExcelTipsVideos]

Glad to hear that… thanks

[@mariacas7974]

Great explanation!

[@ExcelTipsVideos]

Glad it was helpful!

[@sangeetavhatkar148]

THANK YOU SIR. YOU EXPLAINED SO EASY.

[@ExcelTipsVideos]

Glad that it helped

[@waleedazimi9943]

Very helpful

[@nancyattoh8998]

Thank you, this is was so well explained and easy to follow.

[@ExcelTipsVideos]

Thanks

[@raedhalabi188]

Thank you its so clear

[@shinnatangem]

Thanks a lot!!! Are there anyways to convert the final result of this video back to a raw list because I've got a file which already count duplicates however I also needed a raw list too. So I need a way to convert the count duplicate list back to only duplicate list. I hope this question doesn't confused you thankyou

[@sanketnimhan4470]

Very helpful thank you so much

[@ExcelTipsVideos]

Thanks for your support

[@chandansaikia9714]

Informative video

[@ExcelTipsVideos]

Glad that it helped

[@Sunil_Yadav1002]

Thank you sir very use useful

[@Amir-bq8pm]

I love you man ❤️

[@ExcelTipsVideos]

Glad that it helped

[@chujacartoon1]

Very well explained. Thanks a lot.

[@ExcelTipsVideos]

Glad it was helpful!

[@pawankumarvashistha417]

Tahnks from BHARAT (India) !

[@anand12342]

very helpful thanks

[@ExcelTipsVideos]

Thanks for your support

[@MrNaturalcure]

How to do this if the same data is in adjacent 8 columns ? Thanks

[@ungkesuleh4137]

Thank you so much. So helping for me to make a schedule better.. +subbed..

[@ExcelTipsVideos]

Thanks for your support

[@saidaismail9612]

so easy to follow! thanks

[@ExcelTipsVideos]

Thanks for your support

[@ngonimichaelmayeresera749]

best example ever

[@harish70782]

Thanks siir ji🙏

[@moesadr3342]

Does anyone knows how to make this automated that the result will dinimically changes as we enter or edit the records and / or thier values?

[@dr.roshenjohn1401]

such a great help this is

[@ExcelTipsVideos]

Thank you for your support

[@youcantseeme1554]

Thank you so much...this helped me a lot ❤️

[@ExcelTipsVideos]

Glad that I could help

[@JayGreezy]

Thanks buddy.

[@ExcelTipsVideos]

Glad that I could help

[@delossantosjoshual.1459]

Thank you for the tips! Now I can easily solve the mean😅

[@ExcelTipsVideos]

That is really a good use of this formula 😀😀😀

[@cyjohntv4465]

thanks a lot sir

[@rachitajindal4064]

Thanks it was very helpful

[@ExcelTipsVideos]

Glad to hear that!

[@MrDhunpagla]

Neat & informative 👍

[@ExcelTipsVideos]

Glad it was helpful!

[@jeevanandhamvivekanandan8540]

Good one

[@ExcelTipsVideos]

Thank you for your support

[@shreyashh]

Thank you so much for this video.

[@hazimmohamed3217]

Thank you for my assignment easier..keep continue to give a useful knowledge in next video..Much lovee😇😇

[@R10ap]

This was soo helpful, thank you so much!!!

[@ExcelTipsVideos]

Glad that I could help

[@sanalkumar6053]

I think it doesnt count the non repeated item as 1 . Count column cannot be 1 . Is there any way to solve this.

[@sourabhsankpal9297]

thank you

[@ExcelTipsVideos]

You're welcome

[@Cherryb0nb0ns]

THANK YOU SO MUCH!!

[@kanchanchatterjee3193]

Thank you! Nice video

[@ExcelTipsVideos]

Glad you liked it!

[@travismills5972]

Thank you!

[@alimaa.taboure8133]

why does it keep saying : you can't change part of an array ? Thank you

[@ExcelTipsVideos]

That error means you are trying to edit part of a array. You will need to select the entire array

[@prateekagrawal1989]

Thank you so much.

[@prony5145]

Great thank you💓

[@madhavipillai9108]

How to find duplicates comparing two sheets in one excel?? Please reply..

[@ExcelSmith]

Hello. The first step is to create a list of unique values like in column I in the video. The easiest way is to follow the same steps as in the video for the values in Sheet1. Then, copy the values from Sheet2 and paste them below the copied values from Sheet1. This will give you a long list containing all of the values from Sheet1 and Sheet2. Then, like in the video, use Remove Duplicates to get a list of unique values across both sheets. To find how many times each of these values occur in both Sheet1 or in Sheet2, we can add two COUNTIF functions together. The first COUNTIF counts the unique values in the list of values in Sheet1. The second COUNTIF counts the unique values in the list in Sheet2. For example: The range A2:A6 in Sheet1 contains the values A; B; C; B; C. The range A2:A6 in Sheet2 contains the values B; C; D; B; D. Create a list of unique values starting in cell C2 on Sheet1. The unique list would contain the values A; B; C; D. Entering =COUNTIF($A$2:$A$6,C2)+COUNTIF(Sheet2!$A$2:$A$6,C2) in cell D2, and dragging down, gives us the final result: Unique Values Count Duplicates A 1 B 4 C 3 D 2

[@ubaidillahmuhammad20]

useful trick. but please put all practiced files [.*xlsx] in the video description ....Thanks

[@ExcelTipsVideos]

Thanks for the suggestion. I will upload the files in Github and share the link in the Description

[@sahanyakapugedara6770]

Ok thanks 😍😍😍

[@ExcelTipsVideos]

Glad that this was helpful

[@mytechnosupport269]

Low volume problem ?

[@ExcelTipsVideos]

We were trying with a different audio setting....obviously did not work very well 😀

[@FindgrowthPurna4188]

Thank you ❤

[@fathimahjasnawi3165]

mine is not working. Ask to remove the outline. Already remove the borders. Still not function😢

[@shahuljamal1410]

Super

[@debasishmondal19]

Love it

[@ExcelTipsVideos]

Glad that it helped

[@arshkhan9606]

Very low volume

[@hussamkassoumeh7833]

work on your Audio man, I cant hear anything, so low audio recording, Check your video before posting Thanks

[@ExcelTipsVideos]

Thanks for the feedback - I did have issues with the audio at that time - and I have rectified them in my later videos.

[@q-relax7737]

Thank you. Related to above, can you please help with this. Please see below data in column A, The desired result are in column B, how can we get the results in column B with formula. Column A required output in Column B Cell A1= Peter Cell B1= Cell A2= John Cell B2= Cell A3= Peter Cell B3= 1 Cell A4= David Cell B4= Cell A5= Peter Cell B5=2 Cell A6= Blank cell Cell B6= Cell A7= Peter Cell B7= Cell A8= John Cell B8= Cell A9= John Cell B9=1 Cell A10= John Cell B10=2 Cell A11= Maria Cell B11= Cell A12= Blank cell Cell B12= Cell A13= Maria Cell B13= Cell A14= Maria Cell B14=1 Cell A15= Peter Cell B15= Cell A16= David Cell B16= Cell A17= Maria Cell B17=2 I have used =SUBSTITUTE((COUNTIF($A$1:A1,A1)-1),0,"") but it works fine only untill first blank cell in column A. In B7 this formula is giving 3, but it should be blank. Basically after every blank in Column A a new set of data develops. The requirement is to serial the duplicates between two blanks in column. Hope this explains the problem. Thank you. Much appreciated.

[@rajesshmech]

Very useful

[@Lumion15]

Very helpful thanks

[@Jas_Hari]

Very helpful, thank you

[@mayur7673]

THANK YOU SO MUCH

[@ExcelTipsVideos]

You're welcome!

[@esunilkumar9548]

Thank you so much

[@GWAC0k]

thank you

[@ExcelTipsVideos]

You're welcome

[@jesl.6263]

Thank you!

[@ExcelTipsVideos]

You're welcome!

[@AhmedSalemBEGHAH]

Many thanks 🙏

[@ExcelTipsVideos]

Glad I could help

[@آذادخيالونه-ي3ب]

Thank you So much.

[@ExcelTipsVideos]

Glad that I could help