filtered list

  1. Z

    Count Distinct Values in Filtered Table across Multiple Columns

    Hello, I have a formula that counts distinct values within a range of columns. =LET( ThemeRng,t_MUs[[Theme A]:[Theme C]], SUM(IF(ThemeRng <> "", 1 / COUNTIF(ThemeRng, ThemeRng), 0))) However, I'm trying to figure out how to do the same thing when a Table column is filtered. I found a few...
    • zero269
    • Thread
    • count distinct filtered distinct count filtered list filtered table multiple columns
    • Replies: 6
    • Forum: Excel Questions
  2. J

    Filter Index Formula - How to Exclude Value from List

    Hello, May I ask for some help resolving this query please? I seem to be making an error when I am trying to exclude one field if there is data entered. I will explain further below. I am looking at some data with a series of dates. The dates are used to determine if the submission should...
  3. L

    VBA Copy the first row of data from a filtered list and past in new workbook

    I'm trying to take a list of data, and filter it (This will be done outside of a macro). Once filtered, I want the macro to grab the visible line of data and past that row into a new workbook If I break this code up, it works, but not together. Getting error code 91 Help is appreciated...
    • lfriar
    • Thread
    • copy selection filtered list vba visible row
    • Replies: 0
    • Forum: Excel Questions
  4. C

    Filtering and Sorting in Excel 2010

    I am trying to filter some data on a Spreadsheet dependant on what I input into Cell J3. I would like to automatically filter the data and sort at the same time. I have some titles in row A20 to D20. The data in row B21 onwards should be the same as the info as what I input in cell J3, however...
  5. T

    Filtering and multi-selecting values

    Hello All, I'm looking for a way to select values and filter a set of values in a cell based on another value in a separate cell. Example: <tbody> Type of Candy Subtype of Candy Candy Bars Snickers, Milky Way Candy Bars, Fruity Candy Snickers, Starburst </tbody> You are able to select...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top