+ Reply to Thread
Results 1 to 3 of 3

Help needed- Need a formula/ or any other help in extracting Data

  1. #1
    Registered User
    Join Date
    12-28-2018
    Location
    New Jersey
    MS-Off Ver
    2016
    Posts
    1

    Help needed- Need a formula/ or any other help in extracting Data

    Hello, i need help with finding a faster way to extract data form a list. I am attaching a file so may have an idea of what i am actually referring to. On the first tab i have a list with all the individuals and in each column a data referring to them. on this list individuals may appear more than once as they the data is for the whole year for every paydate ( 2x a month). From this list ( 8000 rows), i need only the data for certain individuals ( sheet 2 of the file).
    I need a solution to extract all the rows from the list for these specific individuals. In the past i have had to manually use the filter list and filter them. I have tried vlookup but that brings up only the first entry it finds.

    Please help me and thank you in advance.

    Marie T.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,389

    Re: Help needed- Need a formula/ or any other help in extracting Data

    Hi, welcome to the forum

    So, how would you like this info displayed?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,180

    Re: Help needed- Need a formula/ or any other help in extracting Data

    There's an app for that, that is if you want to take this kind of data and convert it into normalized data.

    Attached is a spreadsheet I developed to normalize data. I cleared out both the Source Data Sheet and Normalized Data Sheet and copied your raw data into the Source Data Sheet. I had to tell the program that I wanted to preserve columns A:D and did this in cell B1 on the control panel sheet. Click the button and the data is transformed into normalized format.

    I did notice that some dates came out as strings. I can't find September 31st on my calendar. You might have some data scrubbing to do.

    It took me longer to explain how to use the program than to actually use the program.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Help Needed: Extracting data from webpage
    By Elangovan89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2014, 08:43 AM
  2. [SOLVED] VBA / Macro / Formula help needed for extracting data and Transpose into another sheet
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-05-2014, 12:19 PM
  3. [SOLVED] Help Needed extracting last two characters to another cell
    By xtraman88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 10:14 AM
  4. Extracting data from multiple sheets, help needed
    By razaas in forum Excel General
    Replies: 2
    Last Post: 11-19-2009, 08:55 AM
  5. [SOLVED] help needed extracting data accross the row into the first cell of the row
    By garyusenet@myway.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2006, 05:35 AM
  6. Formula:Extracting Data
    By Aoife101 in forum Excel General
    Replies: 2
    Last Post: 06-30-2006, 06:39 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