I have a Requests table which includes Date and Speaker_ID among other columns. The following gives me the requests by a speaker, but the list is not sorted.
=REF_ROWS(“Request”, “Speaker_ID”)
How can I sort this list by Date or show the last 10 requests for example?
Modify the system generated inline view for that table. Because it’s a table view, you can sort it with the date field for example.
I am sorry, by “table” I meant the source spreadsheet.
I’m afraid you can’t sort the source spreadsheet itself. You can sort the view.
I am not trying to sort the source spreadsheet. =REF_ROWS(“Request”, “Speaker_ID”) gives me a list of requests for a particular speaker. I need to sort this resulting list by date. Date is a column in Request sheet and not in Speaker sheet.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |