+ Reply to Thread
Results 1 to 4 of 4

if one of the 3 strings is missing sinde the last 6 matches then i want notification

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Gent
    MS-Off Ver
    Excel 2007
    Posts
    6

    if one of the 3 strings is missing sinde the last 6 matches then i want notification

    This is a soccer database where i would like it to notify
    me if weather "d(raw)" weather "l(oose)" weather "w(in)"
    doesnt occur in one of the at least 6 last matches.
    its all explained in the excel file in att

    ty in advance

    best regards

    alain de pauw
    Attached Files Attached Files
    Last edited by thealian; 11-24-2012 at 03:42 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: if one of the 3 strings is missing sinde the last 6 matches then i want notification

    No VBA really needed, I don't think. You can just add more tracking columns to the right and evaluate the data as you add to it.

    Like so...(attached)

    Now, you can apply some conditional formatting to those new columns to hide the colors/fonts (make the cell go all white) if the value in the cell is less than 6.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    Gent
    MS-Off Ver
    Excel 2007
    Posts
    6

    Thumbs up Re: if one of the 3 strings is missing sinde the last 6 matches then i want notification

    SOLVED

    Mate your a genius to me, if i can win some money with this little app
    i asure you that you'll get a part of it

    of course i studied the whole case, and i understand it, dont believe it myself
    ty soo much

    alain de Pauw


    ps sorry looking for an option to say it solved, cant find it even in advanced
    Last edited by thealian; 11-24-2012 at 03:41 PM.

  4. #4
    Registered User
    Join Date
    11-07-2012
    Location
    Gent
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: if one of the 3 strings is missing sinde the last 6 matches then i want notification

    found hope it says solved, had to edit original message hoohohohoh dear me

    ty again

    alain

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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