Auto Numbering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

prkhan56@gmail.com - 21 Jul 2007 15:21 GMT

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

Reply to this Message

Billy Liddel - 21 Jul 2007 17:02 GMT

Rashid

Assuming that the header is in A1, in A2 type

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

> Hello All,
> Autonumbering
[quoted text clipped - 32 lines]
> Thanks in advance
> Rashid Khan

Reply to this Message

prkhan56@gmail.com - 22 Jul 2007 06:54 GMT

On Jul 21, 8:02 pm, Billy Liddel
<BillyLid...@discussions.microsoft.com> wrote:

> Rashid
>
[quoted text clipped - 41 lines]
>
> - Show quoted text -

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

Reply to this Message

Billy Liddel - 22 Jul 2007 20:50 GMT

Rashid

Your welcome

Peter A

> On Jul 21, 8:02 pm, Billy Liddel
> <BillyLid...@discussions.microsoft.com> wrote:
[quoted text clipped - 3 lines]
> >
> > =IF(ISNUMBER(B2),MAX($A$1:A1)+1,"")

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

Reply to this Message