=filter() feature of google sheets not in EXCEL
The function =filter(a,b,c,....) that I have used in Google docs to great advantage, does not seem to be available in EXCEL. Can any one help with an alternative way of achieving this. Example : List of club members with comprehensive data on primary spreadsheet which is updated to show that membership fees have been paid. Required : a second tab that shows only those members who have not paid. This works in Google Sheets (Docs), the "Not Paid" tab being updated automatically on updating the primary data.
|