In Word there is AutoNum-field that inserts an automatic number: 1. 2. 3. 4. 5. etc whereever the field is located. I was trying to find this feature in Excel but I coulnd't.



So, do I have to make automatic numbering with formulas? I can be very complicated because the numbers are at random places all over the document.

Hi ilkks,

Excel doen't provide that kind of facility. If you provide some more detail on what you're trying to achieve, maybe something could be worked out.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Ilkks
See the link below this may give you what you want.
Tony
http://www.techrepublic.com/blog/mso...preadsheet/293

Hi Tony, it is something like that that I am looking for. But in my case it is a a bit more complicated.

In A1, I have the numbering. In B1, product name. Product has 1-5 features that are listed in rows C1-C5. So the next automated number can be in cells A2, A3, A4, A5 or A6, depending on how many features/rows the previous product has.

So the code would be something like this:

IF(There is text in B#,Insert number [1,2,3,4,...] in A#,blank cell)

I have trouble to make this formula working.

Hi ILKKS
Are you able to post a sample spreadsheet to help us understand better what you need?
Tony

Example Excel-sheet attached.

There should be ascending numbering at column E. How to make blank cell instead of space " "?

And 'Total price' should sum up every cell next to text "Price", but that formula is also failing.

Attached Files

ExcelSheet.xlsx (10.7 KB, 26 views)

Hi Ilkks
I am not sure if this is what you want but I have modified the formulae slightly. What will happen now is if you insert extra rows against each product the numbering will still run ascending.
If this is not what you want please provide more info and I will see what I can do.
Tony

Attached Files

Copy of ExcelSheet(1).xlsx (10.7 KB, 19 views)

That formula works if the rows between products stays the same. But the amount of rows varies. I am looking for a formula that is in cells E10...E999, so when new product is inserted it automaticly increase the position number by one.

A solution can be this: in cell E6 enter this formula for the start
=IF(D6=0;"";1)
and in next row, same column:(E7)

=IF(D7=0;"";COUNTIF(E$6:E6;">0")+1)
You can copy this cell to your range (only formula without format) and it will work
you will find this solution in the modified file

Now stop surfing the net and start working :)
Your country needs you

Attached Files

Copy of ExcelSheet(1).xlsx (23.6 KB, 28 views)

Thank you Catalin! This works perfectly!

Glad to help
Ilkks, that was simple, we expect you to do greater things... Almost any work can be simplified with the right approach...