Displaying a List without blank rows

[Davidns]

I have a sheet that has two columns - one with a name and the other a date.
I use another sheet to show all results for a certain date. For example, sheet one shows:

David 10/1/19
Adam 9/30/19
Mary 8/1/19
Jill 8/15/19
Mark 10/1/19

Sheet two then has a user defined date input. Say, for example, 10/1/19. The results then show up as:

David
Blank row
Blank row
Blank row
Mark

Ideally, I would like to see the results without blank rows, but am having trouble figuring out how to do so. Any suggestions would be appreciated.
Thanks!

 

[mumps]

How are you showing the results in sheet two? Are you using a macro? If so, please post your code.

 

[Davidns]

Good question. Sheet two actually shows every row in Sheet 1, but I use conditional formatting to "white out" the rows that do not have the desired date, thus only showing the rows that have the desired date. This is probably not the best way to produce the results I want, but it does work. The problem, as I wrote, is that it ends up displaying a bunch of "empty" rows. I keep thinking there may be a search function based on font/color, and if so, perhaps I could then create a third sheet that only displays the colored cells. If this isn't possible, perhaps there is a better way to produce sheet 2 itself?

 

[Michael M]

Why not simply use autofilter for the selected date on Sheet2 ??

 

[Fluff]

How about

Book1
	A	B
1	Name	Date
2	Tom Pearce	01/10/2019
3	Bill Brewer	02/10/2019
4	Jan Stewer	03/10/2019
5	Peter Gurney	03/10/2019
6	Peter Davy	05/10/2019
7	Dan'l Whiddon	01/10/2019
8	Harry Hawke	07/10/2019
9	Tom Cobley	01/10/2019
Sheet1

Book1
	A
1	01/10/2019
2	Tom Pearce
3	Dan'l Whiddon
4	Tom Cobley
5
6
Sheet2

Cell Formulas
Range	Formula
A2	=IFERROR(INDEX(Sheet1!$A$2:$A$9,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$9)-ROW(Sheet1!$A$2)+1)/(Sheet1!$B$2:$B$9=$A$1),ROWS($A$2:$A2))),"")

 

[Davidns]

Thank you both for your help. Much appreciated!

 

[Fluff]

Glad we could help & thanks for the feedback