Minute 09:00 — 10:00
typically just stick with this one so you can do that and it’s going to highlight you know something that has a duplicate value in there now why do i use this so much well i work with a lot of different types of data sets but one thing that you’ll find in almost all of them is they have some type of id and they’re going to have some type of personal information whether that’s a social security number or an address or you know or a cell phone number or something like that there is going to be data that is going to identify that person now i work a lot with pharmaceutical data a lot with pharmacy data as well as healthcare data so like names social security numbers addresses phone numbers all those things all that customer or client information and oftentimes when i get a new data set and i have it in excel or i convert it to excel i will start using these duplicates to try to find issues with