Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2016, 07:39 AM
peter.threepins peter.threepins is offline =filter() feature of google sheets not in EXCEL Windows 10 =filter() feature of google sheets not in EXCEL Office 2010 64bit
Novice
=filter() feature of google sheets not in EXCEL
 
Join Date: Jul 2016
Posts: 1
peter.threepins is on a distinguished road
Question =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.
Reply With Quote
  #2  
Old 07-13-2016, 08:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline =filter() feature of google sheets not in EXCEL Windows 7 64bit =filter() feature of google sheets not in EXCEL Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,434
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Hi
perhaps a Pivot Table with slicer using a Table as Data Source?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
=filter() feature of google sheets not in EXCEL how to filter column by last working day in excel AC PORTA VIA Excel Programming 17 02-20-2017 06:07 PM
=filter() feature of google sheets not in EXCEL Excel Validation Feature to Return Items from a List summerabc Excel 1 01-16-2015 04:37 AM
=filter() feature of google sheets not in EXCEL Excel sheets ubns Excel 4 04-15-2012 10:48 PM
merge excel sheets Mahen Excel 2 08-03-2011 12:21 AM
=filter() feature of google sheets not in EXCEL Excel feature for Word YooNaa Kim Word 2 01-28-2011 11:50 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:51 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft