Auto Numbering

[prkhan56]

Hello All,
Autonumbering

I am using Office 2003 and have the following problem

Col B
1 Mar-07
2 Sales
3 Sales
4 Mar-07
5 Sales
6 Apr-07
7 Apr-07
8 Sales
....
....
....
I wish to enter in Column A, a formula which when dragged down should
show me Nos. 1, 2, 3.... Only against the Months (viz Mar, Apr, May...etc)
The Cell in Column A against the Word "Sales" in Column B should be
blank.
The Output should come as follows:
Col B
1 Mar-07
Sales
Sales
2 Mar-07
Sales
3 Apr-07
4 Apr-07
Sales
....
....
Any one can help me in the right direction!
Thanks in advance
Rashid Khan

 

[Billy Liddel]

Rashid

Assuming that the header is in A1, in A2 type

=IF(ISNUMBER(B2),MAX($A$1:A1)+1,"")

 

[prkhan56]

Rashid

Assuming that the header is in A1, in A2 type

=IF(ISNUMBER(B2),MAX($A$1:A1)+1,"")







- Show quoted text -

Hi Billy,
Thank you very much. Works fine.
Rashid Khan

 

[Billy Liddel]

Rashid

Your welcome

Peter A

Hi Billy,
Thank you very much. Works fine.
Rashid Khan