Aug 28 2008

Quick Way to Check for Duplicates in a Column

I have been using this quick trick lately to check for duplicates in a column of values.  Let’s say you have a list of a large group of numbers (characters work as well) and want to see if you have more than one instance of any of the numbers.  To check for that, one simple […]

May 3 2007

Sumif and Countif Formulas in Excel

There are many times when analyzing large amounts of data when you might want to sum or count a column or range based on certain criteria. One example is if you have a database of products you have sold, you might want to know the sum of profits for a particular product – which is […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks