Invoice No [Solved/Closed]

Report
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
-
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

Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
43
@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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2400
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
519
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.
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
43
@ 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
Posts
2400
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
519
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.
Posts
2400
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
519
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.
Posts
54
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
43
@Zohaib R


Thanks for Your Response

With Regards

Patnaik