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