+ Reply to Thread
Results 1 to 3 of 3

How do I extract dates from a list

  1. #1
    Registered User
    Join Date
    11-03-2012
    Location
    Nottingham, UK
    MS-Off Ver
    Office 365
    Posts
    59

    How do I extract dates from a list

    Hi all. For my next bit of my project, for each ball I would like to list the dates that they were drawn. There will be two lists, one for main draw and one for bonus draw - taken from 'Draws' tab, columns C, D:I and J.

    I have created a third sheet, and manually put in the first few results. But there are over 2500 draws, each with seven balls! And the list gets longer each week. I'm not sure how possible this will be - I am beginning to think that I have created something of a monster

    As the icing on the cake, I would like to apply a conditional format to the results to differentiate between Saturday and Wednesday draws e.g. Blue text for Saturdays, red for Wednesdays.

    If someone could get me started on ball number 1, I'd be happy to duplicate it for the remaining 58 balls. I have a lot of time while we are in national lockdown!

    As ever, all help greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,941

    Re: How do I extract dates from a list

    A8 and D8 array formulas:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    copy down
    select A8:Axxx and D8:Dyyy and use conditional formatting with a rule based on formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Good luck and don't forget about Excelforum when you win
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    11-03-2012
    Location
    Nottingham, UK
    MS-Off Ver
    Office 365
    Posts
    59

    Re: How do I extract dates from a list

    Thanks very much indeed, Kaper. Precisly what I wanted

+ 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