Problem with numbering certain rows

[PuRe3V1L]

Hello

I have a movie list:
http://img187.imageshack.us/img187/381/excel2no.png

You can see that they are numbered, manually :/ But say I have a new
movie.. with the letter B, then I have to change all numbers from all
movies after the letter B O_o I don't like that thought and I am sure
there is a way to do it automaticly.
I know if I would just put every movie in each row I could do it with 1
mouse click but I need to keep this lay out.
Only info I can give is that there are 5 'empty' rows every time
between the letters, check the screenshot if you don't know what I mean

I am a totall noob with excel so I would apprieciate ANY kind of help!
and sorry for my english.. if u dont understand something, just ask!
Grtz

 

[JE McGimpsey]

One quick and dirty way:

A7: =IF(AND(B7<>"",B7<>"Titel"),MAX($A$1:$A6)+1,"")

Copy down as far as required.

 

[PuRe3V1L]

One quick and dirty way:

A7: =IF(AND(B7<>"",B7<>"Titel"),MAX($A$1:$A6)+1,"")

Copy down as far as required.

[/QUOTE]

hey thanks for your quick reply!

I tried the code in cell A7 but when I tried to 'confirm' it excel gav
an error, it pointed to: "",B7
:

 

[Dave Peterson]

Try copying directly from J.E.'s post. If it doesn't work again, post the
formula that's breaking.


hey thanks for your quick reply!

I tried the code in cell A7 but when I tried to 'confirm' it excel gave
an error, it pointed to: "",B7
:/
[/QUOTE]

 

[PuRe3V1L]

I always copy paste things because I am too lazy to type it all and to
go against errors :/
When I enter the formula in the cell and I hit the green confirm button
I get an error and excel points to the following section:
http://img172.imageshack.us/img172/6457/excel14fk.png

 

[Ardus Petus]

Is your Excel localized in Dutch?
--
AP

"PuRe3V1L" <[email protected]> a écrit
dans le message de
news[email protected]...

 

[PuRe3V1L]

I am dutch yes but my version of excel isnt, my office is english