Minute 11:00 — 12:00

you know fifty thousand a hundred thousand and there should be zero duplicates in there and you highlight it and then you come right here use the filter and we’re gonna filter and we’re going to sort by the color and it allows you to sort by the color and you have duplicates in there then that’s a problem and you identified a problem super quickly and you know some of those things they slip by because nobody checks it and so that’s something that i i often check and if you go here and you sort by color and there isn’t an option to do this this pink red color then that means there aren’t any duplicates and that’s a really good thing most the time that’s a really good thing so let’s go ahead and we’re going to clear that as well as get rid of our conditional formatting rules now another one that i use a lot is this one right here which is the text that contains honestly this one comes a lot in handy especially