Display first xx records of each date in Excel

I have a large spreadsheet that is sorted by date and time.  I only want to show the first 10 records of each date.  I.e., the first 10 records of 1/1/19, first 10 of 1/2/19, etc.  What's the best way to accomplish that?
Date-Sample.xlsx
shannon_adamsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
You could add a column to the data counting the number of occurrences of a particular date and then apply a filter to that column which restricts the visible rows to the first 10.

Some sample data would help, can you upload a dummy file?
shannon_adamsAuthor Commented:
Thanks, Rob.  I have attached a sample file.
Rob HensonFinance AnalystCommented:
See attached; formula in column D with autofilter applied to show counts less than or equal to 10.

Note use of $ in formula to lock row 1 as the formula is copied down, thus increasing the range for the count.
Date-Sample.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shannon_adamsAuthor Commented:
Rob, thank you very much for your help.  That was exactly what I needed!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.