+ Reply to Thread
Results 1 to 8 of 8

Using a FILTER function within a FILTER function...

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    Costa Rica
    MS-Off Ver
    365
    Posts
    3

    Using a FILTER function within a FILTER function...

    Hi there,

    I was wondering if I could have help figuring out how to use a Filter function within another filter function, so that I could select a desired number of columns in a specific order.

    Excel workbook sample is attached with more detailed instructions.

    Thanks!
    Attached Files Attached Files
    Last edited by AliGW; 09-21-2021 at 01:46 AM. Reason: Solved tag correctly applied - no need to edit the thread title!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Using a FILTER function within a FILTER function to filter columns in a specific order

    There's an explanation of the process here: https://www.excelcampus.com/function...acent-columns/
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-23-2021
    Location
    Costa Rica
    MS-Off Ver
    365
    Posts
    3

    Re: Using a FILTER function within a FILTER function to filter columns in a specific order

    That's a genius explanation, thank you so much TMS!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: [SOLVED] Using a FILTER function within a FILTER function...

    You're welcome.

    Sadly, I can only take credit for finding the link, not the content. I will spend some time over the next few days to learn how to apply the new found knowledge. So, thanks for asking the question

  5. #5
    Registered User
    Join Date
    06-23-2021
    Location
    Costa Rica
    MS-Off Ver
    365
    Posts
    3

    Re: [SOLVED] Using a FILTER function within a FILTER function...

    I need to up my Google searching game lol
    You'll find this new knowledge really useful.
    The filter function is incredible.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: [SOLVED] Using a FILTER function within a FILTER function...

    Ah, I’ve used the Filter function quite a lot recently, especially with Unique and Sort … hours of fun. That said, there's clearly so much more to get my head found.

    Incidentally, I searched for: excel use filter function to rearrange columns

  7. #7
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: [SOLVED] Using a FILTER function within a FILTER function...

    Thanks to TMS for providing such a great link, and also learning new usage from it
    Also download great examples (very fresh, and add my own thinking, which is really useful)
    Last edited by wk9128; 09-20-2021 at 07:09 PM.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: [SOLVED] Using a FILTER function within a FILTER function...

    @wk9128: thank you, and thanks for the rep, much appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Optional FILTER in FILTER() Function
    By Yohnson in forum Excel General
    Replies: 21
    Last Post: 07-08-2021, 07:31 AM
  2. Filter function in Office 365 - filter with designated field
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-28-2020, 10:55 AM
  3. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  4. VB CODE OR FUNCTION FOR FILTER IN Columns /Rows
    By master sachin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 01:42 PM
  5. [SOLVED] Function for VERY advanced Filter- criteria in two columns
    By synses in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-24-2012, 03:19 PM
  6. [SOLVED] Filter function based on rows and columns
    By dj_420 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2012, 10:43 PM
  7. Auto Filter function for hiding columns?
    By telnoman in forum Excel General
    Replies: 2
    Last Post: 05-21-2010, 03:54 PM

Tags for this Thread

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