Total prints number depends on number of invoices

**rajeshn_in** · 04-12-2017, 10:23 PM

Hi Friends,

I have a sheet like attached.

in A column I have invoice numbers, and B & C is how many prints I need to take.

If I have ONE invoice in A column then 1+3 prints in B column and 1 print in C column. If I have TWO invoices in A column then prints will be double.

Please check attachment for better under standing.

Thank you friends.

**protonLeah** · 04-13-2017, 01:07 AM

In column C, count the number of commas in column A and add 1:

Please Login or Register  to view this content.

i.e., subtract the length of A2 without commas from the length with commas and add one resulting in the number of invoices in the cell.

Next, in column B

Please Login or Register  to view this content.

**rajeshn_in** · 04-13-2017, 01:49 AM

Excellent Thank you....

Total prints number depends on number of invoices

LinkBack

Thread Tools

Rate This Thread

Display

Total prints number depends on number of invoices

Re: Total prints number depends on number of invoices

Re: Total prints number depends on number of invoices

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Auto Populate Serial Number From Total number

Userform - Number of text boxes depends on what user enters

[SOLVED] Add number of columns, number depends on different cell

[SOLVED] Total Item number by number and cost seperatly

Auto-Coloring a Cell that Depends on the Number

Consolidate Number of Invoices

Auto number invoices in Excel

Bookmarks

Bookmarks

Posting Permissions