Results 1 to 11 of 11

Count how many times a sequence of characters occurs in a column.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2013
    Location
    Bucharest
    MS-Off Ver
    Office Professional Plus 2019
    Posts
    304

    Count how many times a sequence of characters occurs in a column.

    Good day!
    I am trying to determine a tennis player's tie-break record (7-6 or 6-7) set score.
    In the G column we have the scoreline for that respective match.
    The rules are as follows:
    If the value in the L column is positive (2-0, 2-1), then 7-6 means a WON tiebreak, and 6-7 means a LOST tie break
    however
    If the value in the L column is negative (0-2, 1-2), then 7-6 means a LOST tie break and 6-7 means a WON tiebreak

    To determine if the L column is positive or negative, I am using this formula, there are many other ways but:
    LEFT(L2,1)>RIGHT(L2,1)

    The result that I need, is how many tie breaks (7-6, 6-7) were won and how many lost.
    Probably a helper column is needed.
    Have fun solving!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count how many times a negative number occurs
    By basalisbury in forum Excel General
    Replies: 6
    Last Post: 04-05-2012, 10:29 AM
  2. Count how many times a letter occurs
    By GreenMartian in forum Excel General
    Replies: 2
    Last Post: 03-15-2009, 04:30 AM
  3. I would like to count the # of times a value occurs in Col B base
    By shopaholic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2005, 12:30 PM
  4. [SOLVED] How to count the number of times something occurs within a certain month
    By Joyce in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2005, 02:05 PM
  5. [SOLVED] How do I count the times a number occurs in a given criteria?
    By w_aller in forum Excel General
    Replies: 3
    Last Post: 02-03-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1