Best Way to Sequentially Number Cells

[monroe_17]

Hello,
This is likely quite easy for a super user, I have forgotten how to speak Excel :-/.
My question. I'm formatting some product information to be imported into a new database.
Each product needs its own identifier. Some products have a number of colors, whereas others are only one line item.
So I'm wondering what is the best way to get the result below?
I've tried a COUNTIF formula but it was numbering from the bottom up of the spreadsheet and I couldn't figure out how to fix it.
So I don't know if it needs an anchor or not.
The options I could use involve using the item description (NW Pacific) or perhaps if the item has a value in the price column.
Just wondering what you think the most efficient way would be? And of course what the best formula would be.

Many thanks!

Sequential Number	Item Description	Item Sku	Price
1	NW Pacific Oak Chair	NWP-O-Chair	5.75
1	Chiffon	NWP-O-Chair-Chiff
1	Champagne	NWP-O-Chair-Cham
1	Spindle	NWP-O-Chair-Spin
1	Cinder	NWP-O-Chair-Cin
2	NW Pacific Hickory Chair	NWP-H-Chair	6.25
2	Wool Hickory	NWP-H-Chair-WH
2	Butternut Hickory	NWP-H-Chair-BH
3	NW Pacific Oak Chair Leg	NWP-H-Chair-Leg	3.75
4	NW Pacific Maple Chair Back	NWP-H-Chair-Back	10.35

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[Michael M]

So, you want the sequential numbers as per the sample ??
If so, paste this in A3 and drag down

=IF(D3="",A2,A2+1)

If that's not what you want, please post more info

 

[monroe_17]

So, you want the sequential numbers as per the sample ??
If so, paste this in A3 and drag down

=IF(D3="",A2,A2+1)

If that's not what you want, please post more info

Hi Michael,
Yes - sorry, I do want the sequential numbering as in the sample.
That's great thanks! It looks like I need to have "1" in A2 as an anchor?
So a simple IF true/false kind of thing. Thanks for taking on what is probably way too easy for you!
michelle

 

[Peter_SSs]

You can do it without the anchor if you want.

Excel Workbook
	A	D
1	Sequential Number	Price
2	1	5.75
3	1
4	1
5	1
6	1
7	2	6.25
8	2
9	2
10	3	3.75
11	4	10.35
Numbering

 

[monroe_17]

You can do it without the anchor if you want.

Numbering

*	A	D
1	Sequential Number	Price
2	1	5.75
3	1	*
4	1	*
5	1	*
6	1	*
7	2	6.25
8	2	*
9	2	*
10	3	3.75
11	4	10.35

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:131px;"><col style="width:54px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula A2 =N(A1)+(D2<>"") <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks Peter! I'll try that as well. Oh the many choices. Thanks for taking the time.

 

[Peter_SSs]

Thanks Peter! I'll try that as well. Oh the many choices. Thanks for taking the time.

You are welcome.