At the beginning of each month, I publish a tip to make easier & quicker your use of Excel.
Have you ever faced this situation before ?
A database with empty cells which actually refer to the last “non-empty” cell above.
This is not very handy, especially if you want to do statistics (split per region is this case).
For example, graphs, sumif function or pivottables/charts all require each row to be filled-in. A better database for accurate stats would then have to be :
You will find below a tip to perform the data cleansing required:
Note that I am using the “Go To” command (Press F5) to select all the blank cells in my range.
You can now do your stats !!
Did you like it ? Please share the article, but also your Excel & VBA tips below in the comments section.
Many more to come…