Invoice No

Solved/Closed
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
- Nov 22, 2013 at 03:34 AM
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
- Nov 27, 2013 at 08:46 AM
Hello,

After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some example here that is

Row ColumnA ColumnB ColumnC ColumnD
1 Bill No. Amount Last Bill No. 1
2. 2 100
3. 3 200
4. 4 300

in Column D i am entering the Last Raised Invoice No.
and in Column A it will sum the Column D and Give the Invoice No. for Column B

My Required is if any row is blank in Column B then it will 0 in Column A and Sum the previous Row

Like

Row ColumnA ColumnB ColumnC ColumnD
1 Bill No. Amount Last Bill No. 1
2. 2 100
3.
4. 3 300
5. 4 150

Please guide me how to do that

Thanking You

With Regards

patnaik


6 replies

sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Nov 24, 2013 at 11:17 PM
@Zohaib R

Thank Q Very Much, it's solve my problem

very simple logic you are using with helper Column

really great

Thanks once again for solving my problem

one more request is it not possible to use the formula with out Helper Column

Thanks

With Regards
1
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 23, 2013 at 01:34 AM
Hi patnaik,

I would like to assist you here. If your sheet does not contain any confidential data, please upload the sheet to the below mentioned website and provide me the link to download. I will rework the sheet and will post back the link to download the sheet with calculated fields.

SpeedyShare.com

Waiting to hear from you.
0
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Nov 23, 2013 at 02:32 AM
@ Zohaib R

Thank for your Quick Response, actually i don't have the account of SpeedyShare that's why i give the Dropbox link please download the file

https://dl.dropboxusercontent.com/u/75654703/Invoice%20No.xlsx

if any problem please inform

Thanking You

With Regards

Patnaik
0
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 24, 2013 at 01:31 AM
Hi Patnaik,

Please check the below mentioned hyperlink. I have uploaded the re-worked excel sheet with formula.

Invoice No

Please do write back if this was helpful.
0

Didn't find the answer you are looking for?

Ask a question
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Nov 27, 2013 at 08:30 AM
Hi Patnaik,

There are different ways of doing things in excel. To my mind this was the best method. If you find any other ways of doing this, please post it here.
0
sgmpatnaik
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
44
Nov 27, 2013 at 08:46 AM
@Zohaib R


Thanks for Your Response

With Regards

Patnaik
0