The formula is correct.

You may also try this:
=IF(len(B2)<0,MAX($A$1:A1)+1,"")

Unless the cell contains an invisible text (" " or "space"), both formula may
not work.


Exceleighton wrote:
For some reason it's not working. I entered the formula you mentioned in the
cell adjacent to '25 DODICI' and dragged it down from there. I get this:

1 1809

25 DODICI

1 3 MONTS FLANDERS GOLDEN

1 46ER PALE ALE

2 A LE COQ IMPERIAL EXTRA DOUBLE STOUT

2 ABBAYE DE SAINT BON CHIEN

2 ABITA ABBEY ALE
ABITA AMBER
2 ABITA ANDYGATOR HELLES
ABITA BOCK
3 ABITA CHRISTMAS
ABITA FALLFEST
3 ABITA GOLDEN
3 ABITA JOCKAMO IPA
3 ABITA LIGHT
3 ABITA PECAN HARVEST
3 ABITA PURPLE HAZE
4 ABITA RED
4 ABITA RESTORATION
4 ABITA SATSUMA HARVEST WIT
4 ABITA TURBODOG
4 ABITA WHEAT
4
4 AECHT SCHLENKERLA RAUCHBIER
5 AECHT SCHLEN. RAUCHBIER WEIZ
5

Any ideas?

Say the names are in column B and then in A1 enter 1 and in A2 enter:
=IF(B2<"",MAX($A$1:A1)+1,"") and copy down. For example:
[quoted text clipped - 19 lines]

Thank you!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200908/1