custom filters

  1. J

    Clearing Custom Filter Before Selecting

    Running Excel 365 Pro Plus. Have a table with approximately 100,000 rows with duplicate entries. Have been using conditional formatting and custom filter to identify and sort these entries. Takes 20-30 minutes to run. However, when I want to use the custom filter for another task, as soon as...
  2. J

    creating filtered views

    I have about 500 records belonging to the 50 states and about 20 or so regions. A state can below to more than one region. I need to make it easy for the regions to see the data for their states. I could create separate worksheets for each region, but that would be very inefficient to update...
  3. B

    Creating Quick Custom View from Data Dump File

    As an input, I have a raw data file with a myriad of fields. My business partner needs an output that filters down the results based on a specific field criteria. Our goal is to automat the output in contrast to applying filters and copy and pasting the filtered results. Additionally, one of...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top