filtered table

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

I have a protected spreadsheet of "high volume" users of the Emergency Room. These folks have many visits throughout the year. I need the user to be able to filter existing records by selecting a previous. patient. the filtered data returned should be sorted by patient name and most recent...

Hi, i'm searching for a code to go through a table and register only the visible rows of a filtered table. But all I get is it to register the first visible row of every block of rows: For i = 2 To 2000 With Worksheets("sheet1").AutoFilter.Range.SpecialCells(xlCellTypeVisible).Areas(i)(1...

When this macro runs off of a button on an excel vba form, filter does not work >=1/1/2016 should change the filter to only show dates >= Jan 1 2016, but it does not work. The table data comes in as a date field, but excel does not format the data as a date formate until after I refresh it and...

Hi, I'm trying to do a merge of 2 filtered tables into a 3rd one. Here is a simple example of what I'm trying to do. I have 3 sheets (Husband_Expenses, Wife_Expenses, Family_House_Expenses) and each sheet has a table (Husband_Expenses_T, Wife_Expenses_T, Family_House_Expenses_T) that contains...

Hi I am trying to working with a table where I want a Macro to i 1. Filter a table on column 2 for all entries for "Yes", 2. Set a range object for the visible cells within column 1. 3. Allow for a specific cell to be amended.within those visible cells I have the following code that works...