Count Unique or Duplicate Values in a List

Have you ever had a friend yelled random numbers at you while you're counting values? Aside from wanting to toss your friend in a lake you'd like to have an easier way to count these numbers to tell which are unique and which are duplicates. If the list is small that not a probably to do this type of analysis. If the list is big then forget trying to do it in your mind. Why not just use Excel? It's basically a sophisticated counting application. There's actually a function in Excel called COUNTIF and it counts stuff that meets a criteria. Check our the video below to see how's it all done.