Delete Unnecessary Rows in Excel with a formula

Although it is not possible to delete rows of data with a formula (unless you want to use VBA which we are trying to avoid), there is a way to get Excel to create a separate listing of the ‘cleaned’ or ‘scrubbed’ data. This is useful if you regularly get ‘dirty’ data and find that you repeat the same processes again and again each month. By using clever formula to identify the lines that you want and the lines that you don’t want, you can create a template where each month you only need to copy and paste the data in and Excel does all the other work.

Back to: