+ Reply to Thread
Results 1 to 9 of 9

Function to Pull Entire Row Based on Criteria

  1. 04-14-2020, 04:40 PM #1
    macro12
    macro12 is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82

    Function to Pull Entire Row Based on Criteria

    Hello,

    I am trying to pull the entire row(s) based on a specific criterion (employee ID). I only know how to pull one cell. Is it possible?

    I am using Windoes 10. Sorry I don't see an option to change my profile on my phone.

    Thanks in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-14-2020, 11:41 PM #2
    Eastw00d
    Eastw00d is offline
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Function to Pull Entire Row Based on Criteria

    Maybe you are looking for a pivot

    Cheers
    Erwin
    Attached Files Attached Files
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...
    Reply With QuoteRegister To Reply
  3. 04-14-2020, 11:52 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Function to Pull Entire Row Based on Criteria

    You indicate your windows version, bit not your office version? If you tell me the office version, I can change that for you
    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
    Reply With QuoteRegister To Reply
  4. 04-15-2020, 12:29 PM #4
    macro12
    macro12 is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82
    Hi, I am using Office 2016. Thanks!
    Reply With QuoteRegister To Reply
  5. 04-15-2020, 12:40 PM #5
    macro12
    macro12 is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82
    Thanks for the response. Unfortunately, I will need to calculate the remaining hours for each person after it is grouped and that will be cumbersome to recreate the table on a bi-monthly basis (adding lines etc). Do you know of any possible function to pull all lines?
    Reply With QuoteRegister To Reply
  6. 04-16-2020, 01:16 AM #6
    Eastw00d
    Eastw00d is offline
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Function to Pull Entire Row Based on Criteria

    What you can do is working with an array-formulas (to be entered with ctrl-shift-enter):
    Please Login or Register  to view this content.
    See also attachment
    Cheers
    Erwin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-16-2020, 02:39 AM #7
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,291

    Re: Function to Pull Entire Row Based on Criteria

    Another formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-17-2020, 08:07 PM #8
    macro12
    macro12 is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82
    Thank you, Erwin! You are a genius!
    Reply With QuoteRegister To Reply
  9. 04-17-2020, 08:10 PM #9
    macro12
    macro12 is offline
    Registered User
    Join Date
    05-14-2013
    Location
    Somewhere, Anywhere
    MS-Off Ver
    Excel 2016
    Posts
    82
    Thanks you, Czeslaw! Appreciate your help! Both of you are Excel geniuses!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to pull in entire line of data based on being between two date without skipping lines
    By AMille in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-11-2019, 02:38 PM
  2. How to pull in entire line of data based on date without skipping lines
    By AMille in forum Excel General
    Replies: 3
    Last Post: 12-28-2018, 05:01 PM
  3. [SOLVED] How to match multiple criteria from a list to pull entire row from another worksheet?
    By Ozymandius in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 06-18-2017, 01:39 AM
  4. Cut and Paste entire row based on criteria - Need help
    By NateS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 04:52 PM
  5. Pull entire row to new sheet based on number value in end column
    By cbeck in forum Excel General
    Replies: 1
    Last Post: 09-04-2013, 02:07 PM
  6. [SOLVED] Delete entire row based on 2 criteria
    By coopman64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 03:38 PM
  7. Delete entire row based on criteria
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2011, 09:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1