Aug 19 2020 08:35 AM
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 of how many responses I deleted. Does anyone know how I could achieve this?
Thank you,
John
Aug 19 2020 11:51 AM
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.