Results 1 to 2 of 2

Excel Function to filter and extract data

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    1

    Excel Function to filter and extract data

    Hi I am very new to excel and would appreciate some help.

    I have 2 sheets in my spreadsheet : Data and Filter.

    The Data sheet contains a bunch of raw data organized by Unique ID, Name, Address, Postal Code, Country, Date of Birth, Email.

    I need to be able to filter this data by Unique ID on the filter sheet. I would like to be able to populate the Unique ID in the Unique ID column, and have it automatically extract and populate the corresponding information Name, Address, Postal Code, Country, Date of Birth, Email on the adjacent cells.

    The only unique identifier is the Unique ID and there will be a lot of raw data.

    I have attached the spreadsheet as an example of what I would like to do.

    Thank you! K
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract or filter Data
    By Cathrine Paul in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-01-2021, 11:37 AM
  2. Excel function to dynamically filter data?
    By BrendenSmith in forum Excel General
    Replies: 2
    Last Post: 03-08-2020, 10:49 PM
  3. Extract or filter Data
    By Cathrine Paul in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2019, 06:22 AM
  4. Replies: 1
    Last Post: 06-09-2016, 12:12 PM
  5. Extract data using Advanced Filter and VBA
    By vadivel77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2015, 12:22 PM
  6. Replies: 2
    Last Post: 10-19-2014, 08:59 AM
  7. Extract all data to new workbook then filter and extract to new worksheets
    By graphicgoose in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 08:18 PM

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