+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 equivalent to Google S/Sheet Filter() function

  1. #1
    Registered User
    Join Date
    04-16-2009
    Location
    Kilkenny, Ireland.
    MS-Off Ver
    Excel 2010
    Posts
    42

    Excel 2007 equivalent to Google S/Sheet Filter() function

    Hi,

    Hopefully somebody can point me in the right direction on this one..

    I am porting a pretty large Google Spreadsheet app over to Excel 2007 for reasons too numerous to go into (Google collaboration alone just not worth it!!).

    With Google I was able to use a single formula placed in a single cell (e.g. below) to generate a filtered version of an expansive table on a new sheet.

    Please Login or Register  to view this content.
    However, the Filter() function is not available in XL2007.

    Can anybody perhaps suggest an alternative function / most expedient workaround to achieve the same functionality in the Excel version?

    Many thanks in advance.
    Orson.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Excel 2007 equivalent to Google S/Sheet Filter() function

    How about using the Autofilter and select C2 in column P and "Update Pending / Scoring Error" in column X?

    Place the cursor in your data table and hit ALT - F - F to quickly apply the autofilter functionality to the table. You will see the column title gains a drop down arrow. Click on that and select which values you'd like to filter by.

    hth

  3. #3
    Registered User
    Join Date
    04-16-2009
    Location
    Kilkenny, Ireland.
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Excel 2007 equivalent to Google S/Sheet Filter() function

    Teylyn,

    Belated thanks for the advice, I have since gone off and re-acquainted myself with the AdvancedFilter / VBA functionality and am now back on track.

    Wanted the output on a new sheet so Autofilter would not have been a runner anyway I think.

    Thanks again
    Orson.

  4. #4
    Registered User
    Join Date
    02-03-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Excel 2007 equivalent to Google S/Sheet Filter() function

    May I ask what your solution was? I have the same question.
    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1