MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Excel Tips


Suppose you want to produce a report from a set of data as if you filtered on a column. But what if you wanted a formula-based version of the same thing?

Need to get a list of all of the tax invoice PDF files from a folder in to an Excel spreadsheet. This is easy to do if you are using Excel 2016 on a Windows PC using the new Get & Transform Data tools.

Occasionally, I receive an e-mail from someone who has developed a cool spreadsheet and they would like to donate it, to allow anyone who can use it, to download it for free.

Reset ScreenUpdating for Forward Compatibility with Excel XP.

How to add a certain number to all numbers in a range by using PasteSpecial.

Use Cells(Row, Column).Name = "MyRange" to simplify naming a range.

Use Cells(Row, Column) instead of Range() when looping through several columns.

Every time that I copy data from another application and paste it into Excel, the data is inexplicably being parsed into two columns. What is going on?

For a SUMIF or COUNTIF formula with 2 conditions, you need to use an array formula.

How to quickly navigate to any worksheet.

How to increment a number by one each time the user form is opened.

How to reverse the Sign on a difference.

How to use Index and Match to lookup a cell to the left of key cell

Is it possible to change the worksheet tabname to reflect the value in a cell?

Formula to point always the same column but is free to move to different rows as it is copied.

How to freeze the headers.

If I have 11.5 in a cell how do I get this converted to 11 minutes and 30 seconds in another cell?

How to change the macro so it writes the data to the active cell rather than a named one.

How to get a macro to run automatically when the user opens a workbook.

How to eliminate slashes from file names when saving with macro.