1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. E

    Check status of current filter mode

    I need to understand the syntax and code to determine what filters are currently applied to a spreadsheet so that I can return the filters to the sheet at the end of my macro. I currently have a macro I created to copy and insert a row of data identical to the row your cursor is on. The first...
  13. Darth_Williams

    Filters & Drop Down Lists

    Good afternoon all, I have created a spreadsheet that uses drop down lists to control the data that is entered. A problem that I have encountered though is that I can not now apply filters to my headers. Does anyone know of a work around for this or is it a by product of using drop down lists...
  14. J

    Date Filters

    In the dBase we use at work, that I have been working on for ever and a day, we have a lot of date filters built into queries. I was wondering if there is a simpler way to standardize them, so they all look similar, but perform the functions needed. They all need to be a greater than/equal...
  15. S

    Searching multiple values in Custom Filter

    Is it possible to search for several matching numbers when running a search from the Filter drop down dialog box or even with the 'Text Filters > Custom Filters' option? I tried putting a comma between each value but it didn't work. Thanks in advance.
  16. N

    Advanced Filter

    Hello, I have a workbook with several worksheets and several advanced filters that was working very well, but with unknown reason the advanced filters stop working Below is a link for a test sheet from my workbook that shows how I did the advanced filter Can someone please check it and let me...
  17. R

    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...
  18. B

    how to automatically apply filters within a date range

    I have to keep changing my filters with various date ranges and it's a real pain having to keep checking 20 boxes out of a thousand every time I want to change the range. Is there a way I can specify the dates I want to filter in, say, A1 and A2 (start and end range) and I see the new filtered...
  19. G

    Mixing Advanced Filters and Normal Filters

    Good afternoon! So I am trying to sat up an automatic report for my job where I can use advance filters to type the selected months into the criteria page and have it filter per those months. The macro however uses both Advanced and Normal filters and when I transition between, the entire table...
  20. R

    Keep Pivot filers when updating source data

    Hello, Self taught daily user that occasionally dreams that I have to VLOOKUP people before I can speak to them.. :eeek: I have many pivots per tab. I deleted the source data and replaced it with new data and refreshed all. Some of the filters did not keep, and some did. How do I lock down...

Watch MrExcel Video

This Week's Hot Topics

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