VBA - Count filtered rows in the table

[DocAElstein]

(Using Excel 2013). I think I did what you said


Then I opened the Excel file. ... but, I don’t see anything new



( The csv file is just the table https://i.postimg.cc/PJBXMWqj/csv-Fi...just-table.jpg )

---

So I still don’t understand yet what it is you want a VBA macro to do

---

Try it differently

Forget VBA
Forget Power Query
Forget Computers.

Now let’s say you do everything yourself manually

I give you this Table:


Then you give me these results:


How did you do it? What did you do?

---

I don’t understand how this table, https://i.postimg.cc/4dwkdzc5/I-give...this-table.jpg , can give these results https://i.postimg.cc/bvxjXXN4/You-gi...e-rtesults.jpg ????


Perhaps I just need you to do your post #1, again, in a bit more detail. Tell me exactly what you do so that I know what to make the VBA code do.

For my low level of intelligence, low level of filtering experience, this explanation is not enough…I've a table (3 columns, can be more), and for this table I've three filters
I need count rows for each filter (filtered rows and rows left after filtering),

For example:
How can I have Region filter 72 left / filtered 8 when in table column I ( region ) , I have 100 things to start with??? 72+8 is not 100??

---

---

---

---

I got an idea… let me light a candle in my thinking head, and drink some SchlappenBier medicine:




Is this what you mean:
First I filter by Fname using the whole table and this gets me some things “Filtered”. “Filtered” means this: If I filter, for example, by Fname rr then these 6 lines are removed from the table
Pascale Murray
Harrison Irwin
Sierra Howe
Curran Herring
Blake Herring
Jarrod Mccarthy
So first result will be
Name filter: 94 left / Filtered 6

So now I filter by FRegion using the 94 rows left: For example if I now filter by FRegion ll then these 14 lines are removed
Katell Whitaker
Phillip Hunter
Brett Blackwell
Julian Castill o
Kelly Ware
Jin Mcmlllan
Yasir Rollins
Yeo Allen
Hilel Marshall
Dillon Dunlap
Jin Gilliam
Petra Sellers
Chancellor Ratliff
Halla Hodges
So next result will be
Region filter: 80 left: Filtered 14

And so on….

How does that sound?