# Category Archive: Intermediate

## Compare 2 columns

How to compare 2 columns in Excel?  It’s very simple 😄😎👍 I will show you in this post how to do this with the functions VLOOKUP for the research ISNA for the test IF to customize the final result 😉 But first, let’s start with a live demo 💛❤💙💜💚 Live demo In this worksheet (yes, it’s …

## Using conditional formatting to highlight dates

Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, …

## Calculation without equal

I always wonder why, in most of the offices, there is a calculator close to a computer. It’s totally ridiculous especially if you have Excel on your computer. But a secretary told me that it’s not convenient for her to start with the calculation with the symbol =     In fact, there is a …

## Create an Offset Vlookup

In the case you have a table that contains the same ID for many – or empty cells – it is strongly recommended to reorder your data. To perform this modification, we will use 3 functions , INDEX , MATCH and OFFSET. Problem to be solved We have a table (column A:D ) that lists the sales …

## Extract without duplicates with formula

It is very easy to extract without duplicates data from a table through the menu Data>Remove duplicates. It works great for one or more columns but the thing about this tool is that you can not control data that will be delete. I recently worked on a customer address file by keeping only the most …

## How to round in k\$ without formula?

In many companies, it is difficult to present in a worksheet, big numbers. So, to avoid that, it is better to present  your figure rounded in kilo dollar (k\$) or million (m\$). But how to round in k\$? In this article you will find 3 techniques to display a result in k\$ (or m\$ for the millions]. Each …

## Major update

Recently Microsoft has announced a new public update to Excel 2013. This new release includes major stability and usability improvements in Self Service BI scenarios – especially when Power Query, Power Pivot and Power View are involved. For this one we eliminated over 120 bugs, crashes and hangs. On the other hand, we introduced two new …