Here is what I am trying to fix.
I want the formula to ignore blank rows and then continue the alpha increment. See column I for desired results.
All help is appreciated
<colgroup><col width="128" style="width: 96pt;">
<col width="550" style="width: 413pt; mso-width-source: userset; mso-width-alt: 10057;">
<col width="128" style="width: 96pt;" span="2">
<tbody>
</tbody>
I want the formula to ignore blank rows and then continue the alpha increment. See column I for desired results.
All help is appreciated
G | H | I | |
34 | =IF(H35>0,LEFT(ADDRESS(1,ROWS($1:26),4),FIND(1,ADDRESS(1,ROWS($1:26),4))-1)," ") | Y | perfect |
35 | =IF(H36>0,LEFT(ADDRESS(1,ROWS($1:27),4),FIND(1,ADDRESS(1,ROWS($1:27),4))-1)," ") | Z | perfect |
36 | =IF(H37>0,LEFT(ADDRESS(1,ROWS($1:28),4),FIND(1,ADDRESS(1,ROWS($1:28),4))-1)," ") | AA | perfect |
37 | =IF(H38>0,LEFT(ADDRESS(1,ROWS($1:29),4),FIND(1,ADDRESS(1,ROWS($1:29),4))-1)," ") | cell B37 is blank so this cell should also be blank | |
38 | =IF(H39>0,LEFT(ADDRESS(1,ROWS($1:30),4),FIND(1,ADDRESS(1,ROWS($1:30),4))-1)," ") | cell B38 is blank so this cell should also be blank | |
39 | =IF(H40>0,LEFT(ADDRESS(1,ROWS($1:31),4),FIND(1,ADDRESS(1,ROWS($1:31),4))-1)," ") | AD | this should be BB |
40 | =IF(H41>0,LEFT(ADDRESS(1,ROWS($1:32),4),FIND(1,ADDRESS(1,ROWS($1:32),4))-1)," ") | AE | this should be CC |
41 | =IF(H42>0,LEFT(ADDRESS(1,ROWS($1:33),4),FIND(1,ADDRESS(1,ROWS($1:33),4))-1)," ") | AF | this should be dd |