Excel 2002: How to add running numbers ?
 

Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

Enter this in A2 and drag it down:

=IF(D2="TOTAL :",MAX(A$1:A1)+1,"")

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mr. Low" wrote in message
...
Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word "TOTAL: " at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

One way ..
In A1: =IF(D1="Total :",COUNTIF($D$1:D1,"Total :"),"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

In A2: =IF(D2="Total :",COUNT($A$1:A1)+1,"")
copy down


"Mr. Low" wrote:

Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

Hello Jon,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

--
A36B58K641


"Jon Peltier" wrote:

Enter this in A2 and drag it down:

=IF(D2="TOTAL :",MAX(A$1:A1)+1,"")

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Mr. Low" wrote in message
...
Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word "TOTAL: " at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

Hello Max,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

--
A36B58K641


"Max" wrote:

One way ..
In A1: =IF(D1="Total :",COUNTIF($D$1:D1,"Total :"),"")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

Hello Madam,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low

--
A36B58K641


"Teethless mama" wrote:

In A2: =IF(D2="Total :",COUNT($A$1:A1)+1,"")
copy down


"Mr. Low" wrote:

Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

Hello Madam,

Thanks for your formula.

Low


--
A36B58K641


"Teethless mama" wrote:

In A2: =IF(D2="Total :",COUNT($A$1:A1)+1,"")
copy down


"Mr. Low" wrote:

Dear Sir,

I have the following worksheet :

A B C D E
1 IV791667 5/31/2001 RT158674 1,000.00
2 IV791666 5/31/2001 RT158674 1,000.00
3 IV790692 5/28/2001 RT158674 500.00
4 1 TOTAL : 2,500.00
5 IV796284 6/24/2001 RT158836 3,609.40
6 2 TOTAL : 3,609.40
7 CN025037 7/28/2001 RT158465 26.10
8 RD864412 7/13/2001 RT158465 0.00
9 3 TOTAL : 26.10
10 CN025017 7/28/2001 RT158070 102.60
11 RD861084 6/29/2001 RT158070 0.00
12 4 TOTAL : 102.60
13 CN024979 7/28/2001 RT158063 17.55
14 RD86102 6/29/2001 RT158063 0.00
15 5 TOTAL : 17.55


May I Know what formula i must Input at cell A1 and copy down to get the
sequence numbering for each row which has the word €œTOTAL: €œ at column D ?


Thanks

Low

--
A36B58K641

Excel 2002: How to add running numbers ?
 

welcome, Low
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote in message
...
Hello Max,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low