Extract Range Removing Empty Strings

[ebg777]

Hello

Need help. Worked on this formula pieceing together stuff from google. However it doesnt work. It will work if my range is just standard text, but doesnt work with empty strings in the cell. The range I am extracting from is a column list that shows a cell if its >0 otherwise its "". Apparently google says that ISBLANK does not work with empty strings. Some suggest using COUNTBLANK, however I am without the knowledge of how to edit this formula to get it to work.
<for simplicity="" the="" formula="" is="" listed="" as="" next="" to="" column,="" however="" i="" will="" move="" it="" a="" different="" sheet="" after="" completing="" formula.="" oh="" and="" range="" not="" change="" ever="">

Thanks so much for your help

Column C on Sheet 1
Rows of numbers either 0 or > 0

Sheet 2, Column C
Rows of numbers pulling from Sheet 1 Column C, Showing only if the number >0 otherwise ""

Sheet 2, Column D
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #005109}span.s2 {color: #003ecc}span.s3 {color: #9900cc}span.s4 {color: #92371f}span.s5 {color: #2da33a}span.s6 {color: #ff8a17}</style>=IFERROR(INDEX($C$11:$C$44, SMALL(IF(ISBLANK($C$11:$C$44),"", ROW($C$11:$C$44)-MIN(ROW($C$11:$C$44))+1), ROW(C10))),"")

</for>

 

[steve the fish]

Cant you just sort by column C?

Anyway try:

=IFERROR(INDEX($C$11:$C$44,SMALL(IF($C$11:$C$44<>"",ROW($C$11:$C$44)-MIN(ROW($C$11:$C$44))+1), ROWS($A$1:A1))),"")

Needs CTRL-SHIFT-ENTER.

 

[ebg777]

Cant you just sort by column C?

Anyway try:

=IFERROR(INDEX($C$11:$C$44,SMALL(IF($C$11:$C$44<>"",ROW($C$11:$C$44)-MIN(ROW($C$11:$C$44))+1), ROWS($A$1:A1))),"")

Needs CTRL-SHIFT-ENTER.

No i cant sort it. I tried to leave the explanation simple for sake of you guys. Column D on sheet 2 would technically be on another sheet. Its pulling info form a "worksheet" and then putting it all in a clean form on a final sheet that can be printed.

I will try this formula above. How does the Column A come into play?

 

[ebg777]

It did work!

Curious how the column A at the end of the equation is being used in the formula?

 

[ebg777]

THANK YOU VERY MUCH
It is working. However. So now with the formula working, an issue has popped up. When the Data is changed on Sheet 1, the Data on sheet 2 reflects the changes automatically. However the extract blank removal formula here is not auto adjusting for new data (cells that were blank but now not, and cells that were filled but now blank, etc).

Any particular reason why its not auto adjusting?

Thanks!

 

[ebg777]

Nevermind I figured out my issue
THanks!

 

[steve the fish]

Dont worry about the A1:A1. That's there to produce 1, then 2, then 3 as you drag your formula down. The small requires a number ie 1 being the smallest row number where a value that isn't blank is found in this case.

 

[ebg777]

Dont worry about the A1:A1. That's there to produce 1, then 2, then 3 as you drag your formula down. The small requires a number ie 1 being the smallest row number where a value that isn't blank is found in this case.

Thank you steve. The next step in my build im having trouble with seems like as simple answer im just missing.

Trying to add two cells together only if the cell is empty (cells are a IF false then ""). But keep getting an error

=IF(N11+G11<>"", N11+G11, "") whereas those two cells are showing numbers from another sheet or otherwise blank if <>"")

Thanks

 

[steve the fish]

Try just using sum(n11,g11).