Excel Columns Organization

Occasional Contributor


I have multiple columns of data based on the number of responses I received in a survey per question. I want to be able to delete responses with less than 4 columns, while also keeping track of how many responses I deleted. Does anyone know how I could achieve this?


Thank you,



1 Reply


Count the total number of responses before deletion. Lets say there are 500.

Then, setup a formula that will count the existing responses on the spreadsheet using count, counta, countif, etc. Whichever will work best for you. Then, put =500-counta(b1:b500), or whatever count formula and range you have, and label it "Responses Deleted". Assuming you delete the entire row, the formula should self-adjust.