Excel 2002: How to add running numbers ?

M

Mr. Low

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
 
M

Mr. Low

Hello Madam,

Many thanks for your formula.

It works perfectly well.


Kind Regards

Low
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top