Link to home
Start Free TrialLog in
Avatar of Shannon Adams
Shannon Adams

asked on

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
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

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?
Avatar of Shannon Adams
Shannon Adams

ASKER

Thanks, Rob.  I have attached a sample file.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Rob, thank you very much for your help.  That was exactly what I needed!