+ Reply to Thread
Results 1 to 13 of 13

How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

  1. #1
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    How to filter hunderds of lables in Excel Filters & from Pivot filters?. It is easy to filter one or two label values from filters / pivot filters, if i want to filter hunderds of labels in "Filters" or Pivot "Filters" in excel .. How to do that? It is very difficult to select many labels from filters. Is it possible to use "Regex" - Regular Expressions in Excel Filter or pivot filters... Pls. Help. Pls. find attached the screenshot for your kind reference. Pls. Help
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    No longer active in this forum!

  3. #3
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Hi: I posted in other forum because, i did not got response from this forum more than 24 hours.
    After 24 Hours i posted your forum link in another forum.... But they banned & removed the link (because of mentioning your forum link)
    and advised me to put a fresh post....So. I posted a fresh post in another forum..... that is the reason of cross posting...
    What to do now? pls. advise

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    I advise that you read and follow the rules for each forum before posting. All forums will have a rule about cross posting, most will require you to post a link to each forum that you have cross posted at, so when you start a new thread in another forum, you need to go back and add the link to your existing thread as well.

    If you read the rules (that you would have agreed to follow when you joined each of the forums) then you will find it explained there.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Ramkichn - you need to provide the link we have requested before getting any further help here. Please do this now.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    I Posted Link to this another forum... But they are not allowing me to put this forum link to theirs. So i posted new few post in the forum. The Forum link is below

    https://www.mrexcel com/forum/excel-questions/1110426-how-filter-hundreds-lables-excel-filters-pivot-filters-pls-help.html#post5345240

    Sir /Madam: My intention is to get answers to my query. I am not a spammer. Don't see me as a spammer. I am a genuine member of this forum. I am a learner. I want to learn daily. Your forum is one of the venue to learn. That is the reason i am using this platform. I am upset. If you feel i am not a right member to your forum and not adhere to your rules & regulations pls. remove me from your forum member. My intent is to find solution and not to spam. I also reward those members in your forums who guide me to find solution. Pls. don't treat me as a spammer. If i am not worth better remove me. Thank you. I thank each members in this forum for there kind support. Tell me the procedure to remove myself. I will delete the profile myself. Thank you.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Have you taken a moment to read https://www.excelguru.ca/content.php?184 to understand what cross posting without links is about ?

  8. #8
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Pls. find below my cross posting link. The cross posting link is provided in the mentioned format. I put because of not received the response more than 24 hours

    https://www.mrexcel.com/forum/excel-...ml#post5345240

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Np. BTW are you still using XL2003 as indicated in your profile?

  10. #10
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Now i am using Excel 2010. Updated my profile

  11. #11
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    It still shows 2003

  12. #12
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Updated the Version in the profile again.

  13. #13
    Registered User
    Join Date
    05-09-2014
    Location
    India
    MS-Off Ver
    Excel 2010 on Windows 10
    Posts
    16

    Re: How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

    Requesting to give answer to my query. How to filter hundreds of lables in Excel Filters & from Pivot filters? Pls. Help

+ 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. filter in one pivot table affecting the same filters in another one
    By giorgiov in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-01-2018, 08:42 AM
  2. Pivot Table Filters - 1st filter also filters 2nd filter
    By Steveapa in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-19-2016, 03:32 AM
  3. Is it possible to limit pivot filters to only options that fit other filters?
    By Sleipner9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2015, 07:08 PM
  4. How to filter a field in pivot table using two filters
    By Bluemini in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2015, 12:41 AM
  5. Filter report filters based upon previous report filters!!??
    By jackie_m in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2015, 05:17 AM
  6. Pivot Filters to change simulataneously with other pivot filters
    By ScottBeatty in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-02-2014, 10:48 AM
  7. Controlling multiple pivot table filters with one filter.
    By adoepker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2011, 03:41 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