Invoice No

Solved/Closed
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 - Nov 22, 2013 at 03:34 AM
sgmpatnaik Posts 52 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


Related:

6 responses

sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
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
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.
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
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
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.

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.
sgmpatnaik Posts 52 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Nov 27, 2013 at 08:46 AM
@Zohaib R


Thanks for Your Response

With Regards

Patnaik