+ Reply to Thread
Results 1 to 2 of 2

Formula to extract data according to dates

  1. #1
    Registered User
    Join Date
    11-24-2017
    Location
    nyc
    MS-Off Ver
    2013
    Posts
    1

    Formula to extract data according to dates

    Need a solution,
    Need to sort local election results,
    I have one column with the voting history dates for each registered voter for several years, I’m trying break up the voting dates to able to see which voter voted in which election/year, each date is separated with a semicolon in the same cell, see below example,
    Row 1 has,
    20161108 GE;20131105 GE;20130910 PR;20121106 GE;20101102 GE
    Row 2 has,
    20170912 PR;20161108 GE;20160913 PR;20141104 GE;20131105 GE;20130910 PR;
    Row 3 has,
    20161108 GE;20120320 SP;20081104 GE;General Election 2005;General Election 2004
    I’m looking for a formula that will do text to column and leave blank cells for the missing years, so that column B will have all the 2017 dates column C will have all 2016 dates, so that column D will have all the 2015 dates.
    note: date are left to right, high to low
    Please let me know if you have a solution for me,

    thank you very much

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Formula to extract data according to dates

    =--ISNUMBER(SEARCH(B$1,$A2))
    in row1 there are years

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data between two dates
    By Tarentum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2017, 05:48 PM
  2. [SOLVED] Excel formula to extract dates
    By mark888 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2016, 02:36 AM
  3. Help with a formula to extract dates from SKUs
    By rickyanalog in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-14-2016, 08:17 PM
  4. [SOLVED] Extract Data Between 2 Dates
    By omagoodness in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2016, 12:48 AM
  5. [SOLVED] change formula to extract data from between two dates
    By nigelog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2015, 10:42 AM
  6. Extract data between two dates
    By Ogi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2014, 07:19 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