+ Reply to Thread
Results 1 to 2 of 2

Removing rows based on the date entered

  1. #1
    Registered User
    Join Date
    07-27-2020
    Location
    Illinois
    MS-Off Ver
    2016
    Posts
    2

    Removing rows based on the date entered

    Hello everyone,

    On the attached spreadsheet, I want the names that are left blank once a date is entered in cell A2 to be removed so the only names that appear are employees that are working on that day. For example when you enter 8/16 as the date in cell A2 on the second tab, there are 4 blank cells under the name column. I want the formula to remove the rows with the 4 blanks. The current formula I have is

    =IFERROR(INDEX('Option 1'!$C$3:$C$153,MATCH($A5,INDEX('Option 1'!$E$3:$R$153,0,MATCH($A$2,'Option 1'!$E$2:$R$2,0)),0)),"")

    If anyone can help me get the right formula, I'd appreciate it.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,125

    Re: Removing rows based on the date entered

    Please try the following:

    In SignInOut!A5 and copied down to A31:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This formula takes each of the position numbers present in the appropriate date column and orders them smallest to largest in each row of SignInOut col-A. Your current col-C formula works as-is without change.

    SignInOut col-B as you have it is a mixture of formulas and directly entered values. It needs to be a simple lookup. In SignInOut!B5 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    An update to your workbook with the above changes is attached.

    I hope this works for you, let us know.
    Attached Files Attached Files
    Geoff

    Did I help significantly? If you wish, click on * Add Reputation to say thanks.
    If your problem has been resolved please select “Solved” from the Thread Tools menu

+ 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. copy and paste rows based on date entered in userform textbox
    By scouse13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2020, 08:13 AM
  2. Word - Enter a date and then have other dates update based on the entered date
    By fatal.lordes in forum Word Formatting & General
    Replies: 4
    Last Post: 01-28-2018, 06:51 PM
  3. Replies: 12
    Last Post: 08-05-2015, 05:15 PM
  4. Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  5. Inserting rows based on entered value
    By terrra in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2013, 10:59 PM
  6. Replies: 0
    Last Post: 05-25-2009, 06:58 PM
  7. Delete rows based on date range entered?
    By fzrdiva in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2006, 08:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1