Results 1 to 5 of 5

Count the QTY of specific character of "A???-B???"

Threaded View

  1. 01-12-2016, 04:41 PM #1
    CAABYYC
    CAABYYC is offline
    Forum Contributor
    Join Date
    12-13-2013
    Location
    Calgary,AB,Canada
    MS-Off Ver
    2016,O365
    Posts
    236

    Count the QTY of specific character of "A???-B???"

    Source: A1:A2
    A1=sadfsdA001-B301,A303-B303,A004-B304,A005-B305,sdfs-2324,F987-B345
    A2="sadfsdA001-B301,B304sdfssadlfk-werl,-we"

    Need a formula in B1 and B2 to count the QTY of specific character of "A???-B???" in A1 and A2. thanks,
    Last edited by CAABYYC; 01-12-2016 at 05:17 PM.
    Reply With QuoteRegister To Reply
« 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 to count the numnber of "agree", "disagree" and "N/A" in a filtered list
    By mbeginner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2015, 01:13 PM
  2. [SOLVED] :confused: Auto pick "specific data" and put it in "specific cells" with date
    By pipsmultan in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-27-2014, 03:31 AM
  3. Remove the first and last group in the pivot field that starts with character ">" and "<"
    By anarieadea in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2014, 01:22 PM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  6. Returning an "Error" if specific character is typed into a cell
    By cheddarthief in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2011, 05:16 PM
  7. Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next
    By BCB in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-13-2006, 05:02 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