VBA - Count filtered rows in the table

[sandy666]

filters filtering columns but rows are counting for whole table, that is why this is an Excel Table (source from CSV) not Range

[DocAElstein]

filters filtering columns but rows are counting for whole table, ….

Yep, I guessed that bit right already, …but I almost didn’t, - so in other words you remove(filter) entire rows in the table where you find, for example, rr , in the first table column.

I think I am either 100% there in understanding what you want now, or I am very close.

I also know exactly how you want the final output. I will try to do that eventually. But if I had originally tried to do the output exactly as you wanted from the start, then
_ it would be more difficult for me to change it now,
and
_ I might not have noticed my mistake….

….I have not done so much Excel Filter work so I did not know how filters on table typically work….. I know you know but I forgot my hairy fucking Crystal Bollocks and didn't know

---

…., that is why this is an Excel Table (source from CSV) not Range

I don’t know anything about that, I don’t know what is a Poxy fucking Excel Table is either
Never mind, it's probably not important

---

I will take anothert look later.- I am going now for my long daily jog along my the old railway track.

Its beautiful. I do it early while it’s still sunny, so I get a nice Sun tan on my body so that I will be even more beautiful in my YouTube videos...