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.
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.
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...
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
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!!
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
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.
Best video. I waisted my 2 hours looking for this solution. Thanks.
excellent, saved me tone of sore eyes for checking my eng. schedules, thanks 👍
Great that this helped you..
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...
Finally a video which shows what exactly was needed
Glad that this helped!!
YOU ARE A GREAT TEACHER, THIS CLIP JUST HELPED ME OUT
Glad it Helped!!
Could also use the filter on the duplicate flag column and uncheck the value 1 to show only duplicates. Nice video by the way
It was so useful, thanks for creating such kinds of videos.
spent 30 minutes trying to find this. Thank you good sir.
this saves me hours surely, thanks bro
Great videos, you saved my time ..tq
Glad that this helped
Just what I needed. Thx!!!
Glad that this helped
Thank you for the knowledge my king ❤
My pleasure
That really saved lot of time dude. Thank you
Glad it helped
Brilliant, thanks sir!
Glad that you liked it
You saved my time with this solution, thank you
Glad that this helped you
Thanks for clarification
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.
It helpful for me❤️❤️❤️❤️Thanks Sir
Glad that this helped you
Very good, thank you
Glad that it helped you
Thanks you sir you saved my lot of time.
Glad that this helped
Very much informative, thank you so much
Excellent Very helpful
To coy paste the formula... What u r using like keyboard or mouse to print all the values.
Very helpful video
Glad to hear that
Excellent walk through. Thank you
Thank you!
You’re welcome
Thanks a lot for your effort
Glad that this helped you
Thanks for the video
Thanks for tutorial, it actually helped. Chao 🤟🏻🤗
simple and on to the point.Thank you
Nice work!
saved time thanks dude
Glad that this helped you
Such a lovely information
very helpful.. thank you
thank you it was helpful
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...
Nice for working with parts
Thnks Dude, it's helpful.
Many Thanks
You are welcome
Thank you so much!! Very helpful!
It is so much easier for me. Thank you.
Glad that this helped you
Thanks
Thank you sir
Thank you very very much!!!!
Thank you
thanks dear..
Very helpful
Glad to hear that
Thank you.
Your are welcome
Thank u.
TY!!
Glad that this helped you
THank You
Tq,very much..
Great Video!!!!!!!
Thank you❤️❤️
Good sir Thanks But Video Are Clear
thanks; it was awesome
thanks
VERY NICE VIDEO
Thank You
Excellent
Thank u nice one this
Thank you so much!
Nice sir
Nice
Thanks
Brilliant
Glad that you liked it
Very good but no classic style is found in format style so how can it i find & segregate the duplicate?plz
Awesome!!!
If we enter the same data in the format one more time it will High lite or not
Superb
Ty
Q. All Qty of duplicate Order Number are added together
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..
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
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
How to Delete the duplicate datas after your final output of delicate data?
How to create pivot out of this duplicate data? I need pivot to show data without duplicate. Is it possible?
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.
How to indigate duplicate entry in next column. We do not want to show counting.
Sir.. I can't see option classic in conditional formatting.... What I do sir pls..
Great
what about zero would come in duplicate column ???? pols help me out!
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
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.
Its not going forward after getting the things reay
👌
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
The problem is we need value and unit price to sum but u delete it.
I can't find the "classic" option
I can't see the formula format can someone write it for me
can you teach me with vba code?
how to do in word excel sheet
What if I am getting 0....?
👍
What if the data is like C1,C2,C3
Any type of data should be identified by this
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
The formula please ...
kichshi nhi dikh rha h videoe. na samjh aa rha h ache se. formula kya likha alg se likho
invisible