Thank god. For some reason my teacher wasn’t telling me at all how to check for duplicates but kept emphasizing that you need to check for duplicates. I was just using ctrl f until I got fed up and went to RUclips.
To finish the table, how would you remove the duplicates now?? with a formula or anything equivalent? Without deleting each row by selecting them particularly...
Thanks! I was wondering... since there's a one-step solution to remove duplicates if there was a one-step solution to identify them without deleting them... but this is close enough.
If there are duplicate names in random row...sagar 5 times ....dhiraj 7 times...faruk 9 times....and so on now i want to give sr no 1 to sagar ,dhiraj 2 and faruk 3....and so on ....how can we do sir
It is going to be a little complicated formula. You will need to count only Upto the current cell. So if sagar is in cell 5 . Then count sagar from 1 to 5 row. If sagar appears in cell 9, then the count will be from 1 to 9 row and so on and so forth. The range of counting is upto the current cell, so you fix top of the range and the bottom of the range changes for each cell
Hello Nilanjana. Yes it may be possible in pivot, but then you will need to update the source data and then refresh the pivot again. In this way you get the duplicate information right in the source database and the changes and updates and quicker
Just a quick question - apart from first column the data in second column and third column was different. How to choose which one to delete. Deleting one by one could be time consuming. Isn't it ?
Although the order number is the same the quantity and value is different. So technically you are correct. These entries are not duplicates in the true sense of the term. You could go to the Data Tab in the home ribbon and use the remove duplicates option to get a list of unique values.
If I have 3 rows that are dups how can I return a “X”or “D” for row 2 and 3 in Col B or C but not in row 1 Col A / Col B/ Col C Row1 = test / / Row2 = test / X / D Row3= test / X / D
Hi, that is realy great and simple. but the data i work with is more complicated. if you can help and mak a vedio on this question: How can I find duplication in time-interval (overlapping time periods) in the same room for scheduling in excel? for example I have reservation data arranged in a table as: *reservation1: start time: 8:00 am, end time: 10:00 am, in room:305 *reservation2: start time:9:00 am, end time: 10:00 am, in room:305 *reservation3: start time: 8:00 am, end time: 9:00 am, in room:305 how can I have excel see that there are "three" reservations in same room!!
Thank god. For some reason my teacher wasn’t telling me at all how to check for duplicates but kept emphasizing that you need to check for duplicates. I was just using ctrl f until I got fed up and went to RUclips.
YOU ARE A GREAT TEACHER, THIS CLIP JUST HELPED ME OUT
Glad it Helped!!
Finally a video which shows what exactly was needed
Glad that this helped!!
Best video. I waisted my 2 hours looking for this solution. Thanks.
Remarkably simple and straightforward explanation.
Oh mate. You are a rock star. I usually deal with above 40 k entries and you just save my hours or so
Glad that this will help you a lot...
excellent, saved me tone of sore eyes for checking my eng. schedules, thanks 👍
Great that this helped you..
this saves me hours surely, thanks bro
It was so useful, thanks for creating such kinds of videos.
Thank you for the knowledge my king ❤
My pleasure
Great videos, you saved my time ..tq
Glad that this helped
Best video found on this topic
It helpful for me❤️❤️❤️❤️Thanks Sir
Glad that this helped you
spent 30 minutes trying to find this. Thank you good sir.
Nice work!
Very much informative, thank you so much
Such a lovely information
Brilliant, thanks sir!
Glad that you liked it
Just what I needed. Thx!!!
Glad that this helped
Can we use unique function for this
Thnks Dude, it's helpful.
saved time thanks dude
Glad that this helped you
Thanks for tutorial, it actually helped. Chao 🤟🏻🤗
Very helpful video
Glad to hear that
Thanks you sir you saved my lot of time.
Glad that this helped
That really saved lot of time dude. Thank you
Glad it helped
thank you it was helpful
You saved my time with this solution, thank you
Glad that this helped you
Excellent Very helpful
Thank you❤️❤️
Thanks for clarification
Nice for working with parts
how do i get microsoft office for mac like how you did yours?
Thanks a lot for your effort
Glad that this helped you
To finish the table, how would you remove the duplicates now?? with a formula or anything equivalent? Without deleting each row by selecting them particularly...
Thank you!
You’re welcome
Great Video!!!!!!!
Very good, thank you
Glad that it helped you
thanks; it was awesome
Hi, Not able to find duplicates for 18 digits. Could you please help me to find
Could also use the filter on the duplicate flag column and uncheck the value 1 to show only duplicates. Nice video by the way
Thank you very very much!!!!
Excellent
simple and on to the point.Thank you
Thank you so much!! Very helpful!
Excellent walk through. Thank you
Good sir Thanks But Video Are Clear
VERY NICE VIDEO
It is so much easier for me. Thank you.
Glad that this helped you
TY!!
Glad that this helped you
Many Thanks
You are welcome
Very helpful
Glad to hear that
thanks dear..
To coy paste the formula... What u r using like keyboard or mouse to print all the values.
Thank u nice one this
If we enter the same data in the format one more time it will High lite or not
How to create pivot out of this duplicate data? I need pivot to show data without duplicate. Is it possible?
Very good but no classic style is found in format style so how can it i find & segregate the duplicate?plz
Thanks! I was wondering... since there's a one-step solution to remove duplicates if there was a one-step solution to identify them without deleting them... but this is close enough.
Thank you.
Your are welcome
Awesome!!!
Superb
Thank you so much!
Nice sir
Thanks sir
Happy that this helped you
THank You
Brilliant
Glad that you liked it
what about zero would come in duplicate column ???? pols help me out!
thank you sir
Its not going forward after getting the things reay
Thank you
thanks
how we can find duplicate name which is in different format ( may be one name is short form another one in full name) in excel
Nice
Thanks
If there are duplicate names in random row...sagar 5 times ....dhiraj 7 times...faruk 9 times....and so on now i want to give sr no 1 to sagar ,dhiraj 2 and faruk 3....and so on ....how can we do sir
It is going to be a little complicated formula. You will need to count only Upto the current cell. So if sagar is in cell 5 . Then count sagar from 1 to 5 row. If sagar appears in cell 9, then the count will be from 1 to 9 row and so on and so forth. The range of counting is upto the current cell, so you fix top of the range and the bottom of the range changes for each cell
@@TEKNISHA i got the formula...its IF(previous row cell =the same row cell,number above,number above +1). And still thanks for replying..
Hi TEKNISHA, I want to find duplicates from 2 lists and paste the found duplicates in another sheet. How can I do that?
Yes if we want to trase the duplicate entry between two column how we can do that make video on this please.
Ty
Thank you! Very helpful :-)
Glad it was helpful!
How to Delete the duplicate datas after your final output of delicate data?
Sir.. I can't see option classic in conditional formatting.... What I do sir pls..
I can't see the formula format can someone write it for me
How to put a dollar symbol... every time I do it opens a new small window
You can select the cell in the formula and press F4
What if I am getting 0....?
We can also do that in PIVOT
Hello Nilanjana. Yes it may be possible in pivot, but then you will need to update the source data and then refresh the pivot again. In this way you get the duplicate information right in the source database and the changes and updates and quicker
Q. All Qty of duplicate Order Number are added together
can you teach me with vba code?
How to indigate duplicate entry in next column. We do not want to show counting.
how to do in word excel sheet
What if the data is like C1,C2,C3
Any type of data should be identified by this
I can't find the "classic" option
Just a quick question - apart from first column the data in second column and third column was different. How to choose which one to delete. Deleting one by one could be time consuming. Isn't it ?
Although the order number is the same the quantity and value is different. So technically you are correct. These entries are not duplicates in the true sense of the term. You could go to the Data Tab in the home ribbon and use the remove duplicates option to get a list of unique values.
Great
If I have 3 rows that are dups how can I return a “X”or “D” for row 2 and 3 in Col B or C but not in row 1
Col A / Col B/ Col C
Row1 = test / /
Row2 = test / X / D
Row3= test / X / D
Hi, that is realy great and simple. but the data i work with is more complicated. if you can help and mak a vedio on this question:
How can I find duplication in time-interval (overlapping time periods) in the same room for scheduling in excel?
for example I have reservation data arranged in a table as:
*reservation1: start time: 8:00 am, end time: 10:00 am, in room:305
*reservation2: start time:9:00 am, end time: 10:00 am, in room:305
*reservation3: start time: 8:00 am, end time: 9:00 am, in room:305
how can I have excel see that there are "three" reservations in same room!!
Hi Queen,
I have made a tutorial for this. Please check the link. Hope this helps
ruclips.net/video/Zrm85jXT6AY/видео.html
The formula please ...
The problem is we need value and unit price to sum but u delete it.
👌
kichshi nhi dikh rha h videoe. na samjh aa rha h ache se. formula kya likha alg se likho
👍
invisible