Results 1 to 3 of 3

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

Threaded View

  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.

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