I have a worksheet (called ‘data’) in a Calc workbook that contains a table of forthcoming events and their dates:
EventDescription | EventDate
Jim’s birthday | 2019-03-15
Christmas party | 2019-12-21
5th anniversary | 2019-06-04
etc. The entries are in no particular order but none will be in the past.
On another sheet (called ‘dashboard’), I want to list the five most imminent events, i.e. the equivalent of the SQL “SELECT TOP 5 * FROM Events ORDER BY EventDate”. Can somebody give some pointers as to the best way to achieve this? Thanks.