+ Reply to Thread
Results 1 to 8 of 8

Quantity in column D based on order amount of times the order no appears

  1. 08-19-2013, 09:56 AM #1
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Quantity in column D based on order amount of times the order no appears

    Hi,

    In the attached file I have the order number in column A and if it appears once then I would like the VBA to place a 1 in column D, but if it appears more than once then I would like the amount of times it appears in column D.

    Hope this makes sense and thanks for any help,

    David
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-19-2013, 10:00 AM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Quantity in column D based on order amount of times the order no appears

    Use Pivot Table.
    Reply With QuoteRegister To Reply
  3. 08-19-2013, 10:04 AM #3
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Quantity in column D based on order amount of times the order no appears

    I would like to use VBA because it will be part of a larger VBA project.
    Reply With QuoteRegister To Reply
  4. 08-19-2013, 10:23 AM #4
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Quantity in column D based on order amount of times the order no appears

    This is a trivial problem to solve with a formula. Using VBA really doesn't make any sense. Put this formula in D2 and then copy down:

    =COUNTIF(A:A,A2)

    Just because there is VBA used for something else doesn't mean this has to be VBA.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  5. 08-19-2013, 10:24 AM #5
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Quantity in column D based on order amount of times the order no appears

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 08-19-2013, 10:53 AM #6
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Quantity in column D based on order amount of times the order no appears

    Thanks John, that's great.
    Reply With QuoteRegister To Reply
  7. 08-19-2013, 11:14 AM #7
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Quantity in column D based on order amount of times the order no appears

    You're welcome. Glad to help out.
    Reply With QuoteRegister To Reply
  8. 08-19-2013, 06:48 PM #8
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Quantity in column D based on order amount of times the order no appears

    This one lets Excel do the heavy lifting.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Probably a SUM formula for order no. to get the total amount of order
    By Konnie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2013, 04:29 AM
  2. [SOLVED] Count the amount of times specific data appears based on criter
    By Ash Ford in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-11-2013, 12:19 PM
  3. count the amount of times a word appears in the same column in multiple sheets
    By nicko54 in forum Excel General
    Replies: 2
    Last Post: 12-09-2009, 06:36 AM
  4. Discount prices based on order quantity and package quantity
    By jbrandau in forum Excel General
    Replies: 5
    Last Post: 11-23-2009, 06:24 PM
  5. I want a box with the total number of times ORDER appears!
    By tapley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 09:20 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1