+ Reply to Thread
Results 1 to 4 of 4

Trying to filter from 3rd row onwards without removing 2nd and 3rd row

Hybrid View

  1. #1
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Trying to filter from 3rd row onwards without removing 2nd and 3rd row

    Hi there!

    Im trying to get an overview of data per location which is all done, however when I try to filter I need the first 3 rows to stay put, as they are needed to show what the data represents.
    Right now when I simply enter a normal filter, it removes the 2nd and 3rd row which makes it not usable. If someone can help me out with this that would be much appreciated!

    Heres the file: Attachment 825700
    Last edited by Matthijsajax1; 04-14-2023 at 09:49 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Trying to filter from 3rd row onwards without removing 2nd and 3rd row

    I assume you are referring to Blad 1.

    Demerge cell A1.

    Select Row 3.

    Apply filter.

    Re-merge A1. Is that what you wanted?
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    03-15-2023
    Location
    Amsterdam
    MS-Off Ver
    16.71
    Posts
    6

    Re: Trying to filter from 3rd row onwards without removing 2nd and 3rd row

    Amazing Glenn! its exactly what i was looking for.
    Thank you so much!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Trying to filter from 3rd row onwards without removing 2nd and 3rd row

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

+ 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. [SOLVED] Advanced Filter to extract data from sheets 2 onwards
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-07-2022, 09:53 AM
  2. Filter yesterday onwards
    By cmb80 in forum Excel General
    Replies: 1
    Last Post: 11-14-2017, 02:29 AM
  3. [SOLVED] Extract 5th string onwards but exclude 6th string onwards if found a specificlist of words
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-07-2016, 03:48 AM
  4. vlookup removing filter
    By Keenan Kast in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2014, 11:01 AM
  5. [SOLVED] VBA code to select today() onwards from filter
    By cmb80 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-18-2014, 06:39 AM
  6. Removing Filter
    By mohan_rajun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2010, 06:21 PM
  7. Removing Bad Data, Filter maybe?
    By blakrapter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2009, 01:48 PM

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