D
Dallas101
I am trying to create multiple sections of columns on a spreadshee
where I have =IF(C2=1,SUM(B2:B2),"0") in column D2. This formula wil
either fill in column D with a string of numbers or 0. From thi
output, I am then taking that data and using the formul
=IF(D2="0",A2,"") to copy data to column A63. What I want to do now i
take the output in A63:A119 and remove any cell that is not filled wit
actual data so that I am only left with the list with no empty cell
inbetween. Is there a formula that will allow me to do this?
I have attached a portion of the sheet I am working on for reference.
Thank yo
where I have =IF(C2=1,SUM(B2:B2),"0") in column D2. This formula wil
either fill in column D with a string of numbers or 0. From thi
output, I am then taking that data and using the formul
=IF(D2="0",A2,"") to copy data to column A63. What I want to do now i
take the output in A63:A119 and remove any cell that is not filled wit
actual data so that I am only left with the list with no empty cell
inbetween. Is there a formula that will allow me to do this?
I have attached a portion of the sheet I am working on for reference.
Thank yo