Forum Discussion
Excel Columns Organization
Hello, 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 ...
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.