Fill down ignoring blank rows

[zookeepertx]

Hello all!
I have a weird question and hoping it will be easy to solve.
If I have a list of data and I have a blank row each time the data in column A changes. I want to number each data row incrementally in column H but not have the blank rows included in the numbering. More than half the time, there will only be 1 row of data before the data in A changes, so H would contain - for example - 1, blank, 2, blank, 3.....
However, sometimes there will be several rows where A has the same number and I need each of those rows to have the same number in H.

For example:

A	B	C	D	E	F	G	H
red							1
green							2
blue							3
blue							3
blue							3

Its fine if it just takes a formula because I can just "copy/paste special value" the numbers back into H .

Is there a way to do this without it becoming too complicated of a process?

Thanks for any help you can offer.

Jenny

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1	Colour
2	red							1
3
4	green							2
5
6	blue							3
7	blue							3
8	blue							3
Primary

Cell Formulas
Range	Formula
H2:H8	H2	=IF(A2="","",COUNTBLANK(A$1:A1)+1)

 

[zookeepertx]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1	Colour
2	red							1
3
4	green							2
5
6	blue							3
7	blue							3
8	blue							3
Primary

Cell Formulas
Range	Formula
H2:H8	H2	=IF(A2="","",COUNTBLANK(A$1:A1)+1)

Awesome! Thank you so much! (I'm looking at about 900 lines and really didn't want to key them all by hand, LOL!)

Jenny

 

[Fluff]

You're welcome & thanks for the feedback.