OK, I understand a bit better what you want, but I probably do not understand fully yet.
This is what I done so far:
Here is a macro https://www.excelfox.com/forum/showt...ll=1#post23204
It is also in the uploaded file. It works automatically if you type anything in column A or C or E ( or F * )
It does not get exactly the results you want, but I don’t understand yet how you got those results: I don’t understand how you get this:
" Total rows: 100
Name filter: 80 Left / Filtered 20
Region filter: 72 Left / Filtered 8
Country filter: 22 Left / Filtered 50 "
This is what https://www.excelfox.com/forum/showt...ll=1#post23204 it does:
If you type rr in column A , https://i.postimg.cc/s2G1SXKS/rr.jpg , it tells you automatically this
name Filter by rr will get 6 rows
Pascale Murray
Harrison Irwin
Sierra Howe
Curran Herring
Blake Herring
Jarrod Mccarthy
Total rows in name column was 100
If you type ll in column A it tells you this
name Filter by ll will get 14 rows
Katell Whitaker
Phillip Hunter
Brett Blackwell
Julian Castillo
Kelly Ware
Jin Mcmillan
Yasir Rollins
Yeo Allen
Hilel Marshall
Dillon Dunlap
Jin Gilliam
Petra Sellers
Chancellor Ratliff
Halla Hodges
Total rows in name column was 100
If you type sh in column C it tells you this
region Filter by sh will get 4 rows
Azad Kashmir
Flintshire
Andhra Pradesh
Kirkcudbrightshire
Total rows in region column was 100
If you type u in column E it tells you this
country Filter by u will get 25 rows
Peru
Belgium
Turkey
Turkey
Russian Federation
South Africa
Turkey
United States
South Africa
South Korea
Belgium
Australia
Russian Federation
Belgium
Peru
South Korea
Belgium
Ukraine
Belgium
Belgium
South Africa
Peru
Peru
United Kingdom
Austria
Total rows in country column was 100
*If you then add another column in the table, and add another single column like this
BigAlan.JPG
, and if you then type Big in column F, then it will tell you the truth
alan Filter by Big will get 3 rows
Big Cock
Big Brain
Big Castle
Total rows in alan column was 4
Alan Big Cock Big Brain Big Castle.JPG
If you tell me exactly how you get your results, then I can maybe think again, or maybe whatever….
Reply With Quote
Bookmarks