Sequential numbering

[apgmin]

I need the following help urgently, Please see if you can tell me what to do.

I have 3 codes for 3 sales men, A,B and C

Now everytime that they take expense reimbursement payments, I number the voucher as 1,2,3 and so on. Now the problem is the number here does not reflect the nos. of voucher the sales man has taken in the reference. ( Like salesman A may have 2 nos. of vouchers against him and salesman B may have 1 nos. of vouchers against him )

Like say voucher SL. No. 1 was of Sales man A, voucher No. SL. 2 was of Sales man B and voucher SL. No. 3 was of Sales man A again,

In the excel sheet the serial nos. shows 1,2,3 and so on.

Now If I make a pivot table then I see that Sales man A has 2 vouchers against him ( voucher SL. no. 1 & 3)

I want to make a reference column which will show against voucher SL. no. 1 a number 1 & against Voucher SL No. 3 a number 2, this will denote that it is the second voucher of the sales man A

I did index and then countif, works fine (reference column against voucher SL. no. 3 shows a number 2, To indicate that it is the second voucher of sales man A)

but when I enter voucher No. 3 the reference column against voucher SL. no. 1 also changes from number 1 to number 2. I DO NOT WANT THIS TO HAPPEN

 

[apgmin]

Sir now, any way I can also total the amounts for that particular salesman?


Voucher CODE sr. AMOUNT TOTAL
1 LIG 1 500 500
2 DHA 1 200 200
3 DHA 2 350 550
4 DUR 1 500 500
5 LIG 2 540 1040




I have put the voucher amount


In the total amount, I want to have the total for that particular sales man till that voucher


Example : for voucher 1 it is 500, but when there is another voucher for that particular sales man ( In this case voucher no. 5 ) it should add the earlier voucher amounts ( In this case the amount of voucher no. 1 and voucher no. 5 ) SO 500+540=1040

 

[apgmin]

Sir now, any way I can also total the amounts for that particular salesman?


Voucher CODE sr. AMOUNT TOTAL
1 LIG 1 500 500
2 DHA 1 200 200
3 DHA 2 350 550
4 DUR 1 500 500
5 LIG 2 540 1040




I have put the voucher amount


In the total amount, I want to have the total for that particular sales man till that voucher


Example : for voucher 1 it is 500, but when there is another voucher for that particular sales man ( In this case voucher no. 5 ) it should add the earlier voucher amounts ( In this case the amount of voucher no. 1 and voucher no. 5 ) SO 500+540=1040

 

[SamCV]

conditional total

Hello apgmin...

Yesterday I placed an option in the thread you posted in Excel Forum. Please review it and let us know if this is what you want.

Feel free to comment.
Best regards.