+ Reply to Thread
Results 1 to 4 of 4

Countif Function Doesn't Properly Count Unique Characters

  1. #1
    Registered User
    Join Date
    05-03-2020
    Location
    Lexington, Kentucky
    MS-Off Ver
    Latest
    Posts
    7

    Countif Function Doesn't Properly Count Unique Characters

    Hello, I have a inventory excel sheet that I am working on and am trying to use the count if function to identify unique barcodes that belong to speperate bins (each item is stored in a unique bin in a storage room.) Each barcode starts with the bin it is in and followed by a barcode unique to the item. I am using the countif function to count the barcodes as they are scanned into the sheet but I have encountered an issue. Say my barcode belongs in A - 1 and that is the bin that it needs to be counted in. If I scan it into the list of barcodes it is also added to bin A - 10. I assume the issue is it starts the same way and adds it to both. Is there a way around this? Attached is an example of the issue I am facing.
    Thank you, any and all help is appreciated. If anything needs clarification I am willing to answer.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Countif Function Doesn't Properly Count Unique Characters

    How about putting a space after the 1 for Bin A-1? =COUNTIF($A:A,"A - 1 *")

  3. #3
    Registered User
    Join Date
    05-03-2020
    Location
    Lexington, Kentucky
    MS-Off Ver
    Latest
    Posts
    7

    Re: Countif Function Doesn't Properly Count Unique Characters

    Thanks that actually worked perfectly

  4. #4
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Countif Function Doesn't Properly Count Unique Characters

    No problem --- as long as there is a space between the 1 and the rest of the digits, it should work.

+ 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] Range.EntireColumn doesn't function properly, what is wrong with my code?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2014, 10:00 PM
  2. [SOLVED] Countif(s): Need to properly count a flight plan
    By 0311 Hesco in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 09-02-2014, 12:17 PM
  3. Auto-complete formula function doesn't work properly
    By malahe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2014, 10:04 AM
  4. [SOLVED] count unique values in 3 columns, but countif function not working?
    By frustrated with exce in forum Excel General
    Replies: 3
    Last Post: 06-13-2012, 11:13 AM
  5. Excel drag function doesn't work properly
    By aserf in forum Excel General
    Replies: 2
    Last Post: 05-14-2010, 04:39 AM
  6. VBA function doesn't work properly
    By sumonrezadu in forum Excel General
    Replies: 4
    Last Post: 08-28-2009, 09:38 AM
  7. [SOLVED] built-in function doesn't work properly
    By Calaozao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2005, 02:06 PM

Tags for this Thread

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