#1
|
|||
|
|||
=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. |
#2
|
||||
|
||||
Hi
perhaps a Pivot Table with slicer using a Table as Data Source?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to filter column by last working day in excel | AC PORTA VIA | Excel Programming | 17 | 02-20-2017 06:07 PM |
Excel Validation Feature to Return Items from a List | summerabc | Excel | 1 | 01-16-2015 04:37 AM |
Excel sheets | ubns | Excel | 4 | 04-15-2012 10:48 PM |
merge excel sheets | Mahen | Excel | 2 | 08-03-2011 12:21 AM |
Excel feature for Word | YooNaa Kim | Word | 2 | 01-28-2011 11:50 AM |