| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Message; TA Numbers To Text in Excel 2002 | Excel Discussion (Misc queries) | |||
| Running Excel 2007 & 2002 on the same machine | Setting up and Configuration of Excel | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| Arrow keys in Excel 2002/running Windows XP | Setting up and Configuration of Excel | |||
| Excel 2002 - Filtering numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
