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!

[TABLE="width: 516"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Sequential Number[/TD]
[TD]Item Description[/TD]
[TD]Item Sku[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NW Pacific Oak Chair[/TD]
[TD]NWP-O-Chair[/TD]
[TD]5.75[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chiffon[/TD]
[TD]NWP-O-Chair-Chiff[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Champagne[/TD]
[TD]NWP-O-Chair-Cham[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Spindle[/TD]
[TD]NWP-O-Chair-Spin[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Cinder[/TD]
[TD]NWP-O-Chair-Cin[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]NW Pacific Hickory Chair[/TD]
[TD]NWP-H-Chair[/TD]
[TD]6.25[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Wool Hickory
[/TD]
[TD]NWP-H-Chair-WH[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Butternut Hickory[/TD]
[TD]NWP-H-Chair-BH[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]NW Pacific Oak Chair Leg[/TD]
[TD]NWP-H-Chair-Leg[/TD]
[TD]3.75[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]NW Pacific Maple Chair Back[/TD]
[TD]NWP-H-Chair-Back[/TD]
[TD]10.35[/TD]
[/TR]
</tbody>[/TABLE]

 

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

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:131px;"><col style="width:54px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: center"]Sequential Number[/TD]
[TD="align: right"]Price[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: right"]5.75[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]2[/TD]
[TD="align: right"]6.25[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]3[/TD]
[TD="align: right"]3.75[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]10.35[/TD]

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