+ Reply to Thread
Results 1 to 3 of 3

Total prints number depends on number of invoices

  1. #1
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    686

    Total prints number depends on number of invoices

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,504

    Re: Total prints number depends on number of invoices

    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.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    04-06-2016
    Location
    Singapore
    MS-Off Ver
    MS Office 365 & 2010
    Posts
    686

    Re: Total prints number depends on number of invoices

    Excellent Thank you....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto Populate Serial Number From Total number
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-04-2015, 04:33 PM
  2. Userform - Number of text boxes depends on what user enters
    By Vaish18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2015, 01:20 PM
  3. [SOLVED] Add number of columns, number depends on different cell
    By carrus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-27-2013, 09:19 PM
  4. [SOLVED] Total Item number by number and cost seperatly
    By madhatter40 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2012, 04:34 PM
  5. Auto-Coloring a Cell that Depends on the Number
    By loved07 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2012, 04:47 PM
  6. Consolidate Number of Invoices
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2010, 04:48 PM
  7. Auto number invoices in Excel
    By Fay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2005, 12:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1