XLf(x)s

We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others...

To do a search in a column or a row, MATCH is the function to look for It is very simple, you set the value...

You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to...

I don’t believe I don’t have this here yet. This is one of my oldest tricks When we have to do links between two workbooks...

I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to...

Excel 2010 has a lot of new exciting things, one of them is the ‘Engineering’ category of functions, this was usually a plugin we have...

Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days...