+ Reply to Thread
Results 1 to 3 of 3

Pulling data from another sheet based on certain criteria, without creating blank rows

  1. #1
    Registered User
    Join Date
    04-26-2021
    Location
    New Jersey, USA
    MS-Off Ver
    2016
    Posts
    3

    Pulling data from another sheet based on certain criteria, without creating blank rows

    Hey everybody. I am trying to create a function that would pull data to the "Overview" sheet, from "GMF" sheet, when column D has 30 or fewer days left. I created an IF function that does show the names when criteria is met, but leaves a blank row when criteria is not met. Is there a way to skip the blank rows in the "Overview" sheet so it looks neater? The final "GMF" sheet will have about 150-200 names in it. Is it also possible to pull the column with the name (column A) and the column with the days remaining (column D), similar to what is in the "Sample_Sheet" sheet. This is basically what I am trying to make it look like in the "Overview" sheet. The "Overview" sheet would be printed on monthly basis for employee requalification.

    Thank you for any help!
    Attached Files Attached Files
    Last edited by afreed33; 05-03-2021 at 07:17 PM.

  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 2403
    Posts
    43,893

    Re: Pulling data from another sheet based on certain criteria, without creating blank rows

    In A2, copied down (similar in B2):

    =IFERROR(INDEX(GMF!A:A,AGGREGATE(15,6,ROW(GMF!$A$2:$A$250)/(GMF!$D$2:$D$250<31),ROWS(A$2:A2))),"")
    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.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-26-2021
    Location
    New Jersey, USA
    MS-Off Ver
    2016
    Posts
    3

    Re: Pulling data from another sheet based on certain criteria, without creating blank rows

    Thank you very much for your help! This is exactly for I was looking for. I just had one more question, I did not realize that once the "Days Until" column reaches less than 0, "Overdue" text will be displayed in the "GMF" sheets and the names will disappear from the "Overview" tab since it is no longer a digit. is there a way to also display the rows with "Overdue" from "GMF" sheet in the "Overview" sheet along with the entries that are < 31 days. Thank you very much for your help!

+ 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. [SOLVED] Need Help creating formula to rid a data set of blank rows based of 2 result columns
    By Isara1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2016, 11:16 AM
  2. Pulling Data from a sheet based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-06-2015, 07:46 PM
  3. Pulling Data from a sheet based on criteria on both those sheets
    By mlbdc2012 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2015, 10:39 AM
  4. [SOLVED] Eliminate blank rows when pulling criteria based data from one spreadsheet to another
    By Terisammis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-28-2014, 10:39 AM
  5. Replies: 14
    Last Post: 01-19-2014, 05:42 AM
  6. Pulling rows of data based on criteria in one column
    By Ezekedes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2013, 10:54 AM
  7. Replies: 1
    Last Post: 08-08-2011, 06:00 PM

Tags for this Thread

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