+ Reply to Thread
Results 1 to 5 of 5

order count

  1. 08-20-2020, 08:47 AM #1
    LJMFitnessSolutions
    LJMFitnessSolutions is offline
    Registered User
    Join Date
    08-18-2020
    Location
    staffordshire, England
    MS-Off Ver
    365
    Posts
    6

    order count

    hi, can someone help me with a formula. i have a list of orders in the first column and in the 2nd column i want it show zeros for all but 1 of the same order where i need it to show a 1. i have a attached a sample of order numbers in column A and what i need to show in column B.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-20-2020, 08:55 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: order count

    How about
    =(COUNTIFS(A:A,A2)=COUNTIFS(A$2:A2,A2))+0
    Reply With QuoteRegister To Reply
  3. 08-20-2020, 09:03 AM #3
    bluesky63
    bluesky63 is offline
    Forum Contributor
    Join Date
    03-18-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2016 / 2019
    Posts
    251

    Re: order count

    Hi

    At C2, =IF(A2=A3, 0,1) copy down
    Christopher Yap
    Reply With QuoteRegister To Reply
  4. 08-20-2020, 09:16 AM #4
    LJMFitnessSolutions
    LJMFitnessSolutions is offline
    Registered User
    Join Date
    08-18-2020
    Location
    staffordshire, England
    MS-Off Ver
    365
    Posts
    6

    Re: order count

    thank you so much for this
    Reply With QuoteRegister To Reply
  5. 08-20-2020, 09:16 AM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: order count

    You're welcome & thanks for the feedback.
    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. Need help count repeat order frequency
    By andreaschrist96 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-06-2018, 03:32 AM
  2. [SOLVED] Count dates in order (that are out of order)
    By Mogal in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-01-2018, 11:35 AM
  3. Count and order
    By plakatown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2016, 03:55 AM
  4. count if less than 5 & assign new numbering order
    By tabkaz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-02-2015, 03:31 PM
  5. [SOLVED] Formula to count duplicates in 1, 2, 3 order
    By kas05j in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2014, 11:02 AM
  6. [SOLVED] Count the value based on order
    By huy_le in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-05-2013, 10:33 PM
  7. Problem with 2 conditions in order to count
    By koncurn in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-30-2010, 12:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1