+ Reply to Thread
Results 1 to 4 of 4

Extracting rows based on multiple criterion

  1. #1
    Registered User
    Join Date
    09-09-2019
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    2

    Extracting rows based on multiple criterion

    Hi,

    I am working on a sheet, my team has done lots of building projects. I have two sheets one has all the back up data and other is for users who want to sort out the list and able to find projects based on the criterion. I am unable to work out the sheet now. Can someone help? I have attached the sheet.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extracting rows based on multiple criterion

    In E3, copied across and down:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    09-09-2019
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    2

    Re: Extracting rows based on multiple criterion

    Thank you so much ! You are a genius !

    Just mentioning for someone looking to use the sheet further, add a sign and rest of it works like a charm.

    Backup Data'!$H$5:$H$100='Find Project '!$C$8

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Extracting rows based on multiple criterion

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ 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. Extracting rows of data based on multiple criteria from a list
    By cnak in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2018, 12:10 PM
  2. Replies: 3
    Last Post: 11-22-2016, 06:11 AM
  3. Find value based on item number (first criterion) and date (second criterion)
    By ivan.stajin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2014, 10:47 AM
  4. this is a hard one... Extracting info from raw data based on list of criterion
    By xcelnoob77 in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 04-07-2014, 04:12 AM
  5. [SOLVED] Extracting certain rows based on multiple criteria
    By Nurik in forum Excel General
    Replies: 6
    Last Post: 10-30-2013, 02:05 PM
  6. Extracting rows based on multiple ranges and unique numbers
    By D13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2012, 09:33 AM
  7. Hide rows based on criterion
    By dlorenzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2012, 01:24 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