Results 1 to 10 of 10

Lottery Filter#2, Low/High Digits, in Single CELL with "-"

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Lottery Filter#2, Low/High Digits, in Single CELL with "-"

    Hi,

    How i do, i'm trying to apply some lottery filters on a Tickets that i'm producing on daily basis,
    (i know many on them)

    this filter i Called "Low/High"

    For example :

    1-.the Lottery have number is 36 (lowest 1, Highest 36)

    2-.the 36 Numbers are Identified as two section (Low= 1~18), and (High=19~36)

    3-.In order to Filter out "bad combination", the Array Formula (if any) should
    a-.identify / count how many numbers are from LOW and
    b-.how many numbers are HIGH

    Note :
    Combination are in a single CELL,
    Combination are with "-" e.i ( 01-02-03-04-05 )
    Combination are with 2 digits e.i ( 01-02-03-04-05 )


    Example :

              Column G         Column H    Column J     
              Pick Numbers       SUM       LOW/HIGH
    G6  =    22-33-34-35-36      160        0/5 
    G7  =    08-28-29-30-35      130        1/4
    G8  =    01-18-23-33-35      110        2/3
    please I need to get L/H on Column J

    Is there a way to do this with function formula?


    Thanks YOU ALL.

    David.
    Last edited by david gonzalez; 10-15-2013 at 12:04 AM. Reason: wrong input, sorry, my fault

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lottery Filter#1, SUM in Single CELL with "-"
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-15-2013, 12:00 PM
  2. [SOLVED] Count "A" and "V" as separate characters in a single cell
    By sportboy712 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2013, 12:26 PM
  3. Replies: 2
    Last Post: 09-25-2012, 12:53 AM
  4. Replies: 2
    Last Post: 08-02-2011, 06:57 AM
  5. Macro that runs entered value through "low" and "high" range
    By Vika.F in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2005, 03:35 AM

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