Removing rows based on the date entered

**ilovejellybeans** · 08-01-2020, 01:02 PM

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.

**GeoffW283** · 08-01-2020, 04:27 PM

Please try the following:

In SignInOut!A5 and copied down to A31:

Formula:

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:

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.

Removing rows based on the date entered

LinkBack

Thread Tools

Rate This Thread

Display

Removing rows based on the date entered

Re: Removing rows based on the date entered

Thread Information

Users Browsing this Thread

Similar Threads

copy and paste rows based on date entered in userform textbox

Word - Enter a date and then have other dates update based on the entered date

Calculate dates based on values entered or based on today’s date

Conditional formatting based on date - delete format if a date is entered in next cell

Inserting rows based on entered value

Conditional formating, format based on date entered or percentage entered

Delete rows based on date range entered?

Bookmarks

Bookmarks

Posting Permissions