Excel Columns Organization

Highlighted
Occasional Contributor

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 

1 Reply
Highlighted

@Jbisca 

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.