1. J

    How to remove all filters from the current active Worksheet

    Hi All, I am looking to remove all current filters from the current worksheet. The filters could be on any column or row. Is it possible to have a 'remove all' filters macro? Thanks in advance. Regards, John
  2. M

    Pivot Table Date Filters not formatting correctly

    Using Excel 365 I have a data set that contains a "month" column formatted to "MMM-YY". When I pull this column into the filters section of my pivot table, the options are: "<29/02/2016 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec >01/07/2023" How do I get it to show my desired...
  3. SanjayGMusafir

    VBA to Filter Column Labels using Filter List

    Hi Everyone I need to filter my pivot table column label for Column "D1". I need this because everytime there is new item in D1, pivot table automatically clears all filters and starts showing all items. Just to keep a record that which items I need to be seen, I created a list "PFilters" with...
  4. M

    ActiveX Switching From One Sub to Another

    Hi I'm trying to use vba to filter different lists on the same spreadsheet - so for example I have a list of departments and the teams within, and the same thing for region and location. I'm using these to create dynamic ranges to populate active x combo boxes - so, select a department then the...
  5. C

    DAX to track program expectations - weird relationships

    I am building a dashboard to show progress of employees through a long-term training program. I am trying to create a measure to track progress against time-based expectations, and I'm struggling with the DAX logic. The model I have is a variation on a star schema. The central table is a record...
  6. G

    Run-time error 5: Invalid procedure call or argument in PivotTable filter VBA

    I'm trying to copy, create and rename a sheet named "ASPAC CAP" and update the selection pivot table field of the newly created and renamed sheet. The macro below successfully copied, created and renamed the new sheet. however I'm encountering a code error below when filtering the pivot table...
  7. B

    Providing dynamic date range to PowerQuery

    I have been looking for a while now, and while I've gotten close, I haven't found that cigar. I have a PowerQuery gathering transactions from multiple worksheets in a file, and I'd like to be able to filter to get only those transactions with dates between a StartDate and an EndDate. I've gone...
  8. C

    Control Pivot Table filter based on a cell value from another cell

    Hi all, I hope someone can help... for this particular puzzle I prefer NOT to use Slicers or VBA codes (not sure if this is possible without VBA) I have setup a hidden Pivot Table which I would like to be able to control based on a cell value on another visible sheet. E.g., if I type in...
  9. J

    Excel VBA - Macro to Filter Column if Contains Any Values from Range of Cells

    Hello All, I've scoured the site, but first post, so hopefully I'm clear in the Q description. I've got a worksheet, A-H, 1-100. In Columns C,D,E, there are singular, non-unique values. In Column G, there's a string of values which may contain one or more of the values from C,D,E. I'm trying...
  10. H

    Creating a filter list

    I have 2 worksheets, one where the workings are being done, I'm using =Filter and =Unique commands which gets me a formatted list on Sheet 1. On my sheet 2 is my Report - where it shows the workings out in a nice easy to digest sheet. I'm trying to figure out a way to do filters search from a...
  11. J

    More "labels" in pivot table

    Hi all, I have a list of products in one column, then some other data and lastly the column where is the project associated with that product. This is then going to pivot table to be able to see all products in one project when I filter on it. However, some products are applicable in more then...
  12. J

    FILTERS inside Pivot Table does not update when source data (incl VBA) changes

    Hi, question about pivot table FILTERS (see picture) Situation: I erased my source data and my pivotable refreshes correctly as seen in the picture. this happens automatically as I am using a little VBA code in the source data to refresh my pivot tables automatically. However, when you click...
  13. G

    How to count only true values of a column when filter other columns

    Hi all. I have an excel sheet with the following columns: COLUMN A COLUMN B TRUE PREMIER LEAGUE FALSE CHAMPIONS LEAGUE TRUE LIGUE 1 FALSE PREMIER LEAGUE FALSE CHAMPIONS LEAGUE FALSE PREMIER LEAGUE TRUE LIGA I would to create a cell C1 with the percentage of true values for...
  14. R

    Count Distinct Values after Filter

    Hello, I can usually find what I need to write complex formulas, usually on this forum, but this one has had me stumped for quite some time. I have data contained in a Table (Table1) with named ranges and need to count distinct document numbers where it does or doesn't meet certain criteria...
  15. W

    VBA, Unselect all PivotField filters then select 2 values

    Good morning, I'm pretty unfamiliar with coding any VBA at all, but I do well enough reading it. I'm trying to unselect all filtered values from PivotTable "PivotTable1" PivotFields "CUSNO", then select 2 values that would be in the list of values based on if they exist or not. There's...
  16. F

    Pivot table filters

    Good morning. I have an Excel template that I built to be used on a weekly basis that posts metrics in pivot charts for different sections in our flight (AAA, AAB, ABA, ABB, ABC, ABD). In the template I have a pivot table for each section already built based on the data that gets updated...
  17. I

    Enable filters to affect a cumulative measure

    Hi, I've created various measures to help try and show a baseline plan of implementation versus actual, which works as expected when there's no filters applied. However, when I apply a filter, none of the measures update and instead continue to show the full, 'unfiltered', values. I have tried...
  18. reasem

    Want conditional formatting to reset after column filters are used

    Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...
  19. L

    Lock filters

    Hi Guys. Is there a possibility in excel to lock the filters? Meaning that I do set up some filters for certain columns and I want prevent other file users to modify it ? Note - I do not want to lock cells to be edited, just filters. Or maybe is there a simple clever macro that would show a...
  20. F

    Countif with filters

    Hey guys, I've been trying to use a countif expression that allows me to check for misplaced data, which is pretty easy, however it becomes a lot more tricky when i try to make that same data respond to filters. This is the expression i have used so far COUNTIFS('A...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back