How can I increment alphabetically - problem with skipping rows.

[dstepan]

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

	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

<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>

 

[XOR LX]

Hi,

Unfortunately your posted data appears to contain many inconsistencies and errors, so it's hard to be sure of any solution.

For example, your formula in G34 begins:

IF(H35>0

which is referencing not only row 35 (i.e. the row below), which seems wrong, but also column H, which seems to contradict your comments about it being column B which should be checked for blankness.

Also, it would be useful to know in which row your formulas begin. From the excerpt you give, the portion:

ROWS($1:25)

would suggest that you are beginning in row 10.

Lots of unknowns, but as a first guess, and assuming the entries in column B are text, not numbers, in G10:

=IF(AND(COUNTIF(B$10:B10,">""")=1,B10<>""),"A",IF(B10<>"",SUBSTITUTE(ADDRESS(1,1+COLUMN(INDIRECT(LOOKUP(1,0/(G9:G$10<>""),G9:G$10)&1)),4),1,""),""))

and copied down.

Regards