Create a Unique List in Excel - Feature Image

Create a Unique List in Excel based on Criteria

Nathan is working on a spreadsheet that contains a list of car models and owners. He needs to create a unique list of owners per car. “Maybe I can use an IF() formula,” he thinks to himself and decides to give it a go. However, after several failed attempts he decides to search the web to see how people create a …

Anatomy of Structured references

Structured References [Infographic]

Are your formulas driving you crazy? Do they have a multitude of $ signs, colons, and letters referring to various columns? How many times have you looked at your complicated formulas and asked yourself “What data is this referring to?” I know I have. I mean, it’s not always easy remembering what $B2:$D10 is referring to. Luckily, we can leverage Structured …

join cells in excel

How to Join Cells In Excel with a Comma (or other delimiter)

There are times where I need to join cells in Excel and separate them with a comma or some other text. I usually need this to make a SQL query or something like this. Whatever the case may be, Excel doesn't seem to have an easy way to join multiple cells with a delimiter like a comma. So I've created a ...
how to capitalize names in Excel

How to Capitalize Names in Excel

Having nicely formatted data is a must if you plan on showing your spreadsheets to anyone who's willing to look at them. And while you may know how to color or change the font type, sometimes (well, maybe a lot of the time) your data itself might need some formatting from within. One of those times you may need to ...

Alternative to Multiple IF Statements

Have you ever had to create a multiple IF statement? Ever notice how crazy it looks with all those parentheses and it's difficult to follow? Well, I was wondering if there was another way I could create a multiple IF statements that would be cleaner and easier to edit if need be. And I have. What I have discovered isn't ...

Array Formulas for Beginners

Excel Array formulas are one of the handiest tools to have under your Excel tool belt. You can expand regular Excel formulas to provide a lot more power to regular functions. Take the function AVERAGEIF() as an example. Before Excel 2007, you had to use array formulas to provide the same functionality. And while array formulas are extremely powerful, they can ...

How to Put Quotation Marks in Excel Formulas

When you add text in a formula in Excel, you have to enclose the text with quotation marks ("...").  This is useful for when you want to create a dynamic string that changes based on some conditions.  But what happens when you want to put quotation marks as part of the formula's result?  In this post, I'll be talking about ...

Vlookup in Excel

Vlookup (pronounced "vee-look-up") is one of the most popular look up functions in Excel.  When you need to extract data from a table based on a particular value, you can use Vlookup to do that.  In simple terms, it looks at a table in the first column for a specific value and returns a cell in the same row where ...

Excel Conditional Formatting – Highlighting Duplicates

Ever need to find duplicate cells in Excel? There are many ways you can do this. You can use a formula, Excel’s built-in “remove duplicates” functionality, even code a solution yourself in VBA.  However, you can use conditional formatting to see where the duplicate rows are without deleting them.  Normally, people use conditional formatting for highlighting simple things like if …