Search:

later

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
...

It's too complicated, too much green color in your code - I understand nothing!
I have decided not to use vba ever again
thanks for trying , thanks for your time

CF - conditional formatting
Filter - filter each column by NoColor starting from far left
you just retyped in many words all what I show with one table
what is your office version?
could you...

here is table from csv (100 rows)
with CF defined for each filter (hardcoded) then table filtered by No Color
The trick is that the filter should not be hardcoded
with rows counted manually

I need to rewire my brain :cool:

remember to take a pictures :)

it should be a proper result


Count

Total rows: 100


Name filter: 86 Left / Filtered 14

total = Table.RowCount(TPH),
name = Text.From(Table.RowCount(TPH)-Table.RowCount(TSR))&" Left / Filtered "&Text.From(Table.RowCount(TSR)),
region =...

Take more pics from your jogging track
Your YT videos = 0 :confused:

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

here is some results



Count

Total rows: 100
Name filter: 94 Left / Filtered 6
Region filter: 94 Left / Filtered 0
Country filter: 94 Left / Filtered 0

it looks like you say that by opening a clean excel xlsm file I can see a lot of some vba code

maybe this is it
http://www.excelfox.com/forum/attachment.php?attachmentid=5513&d=1692610305

you used it in the first version of vba - first file and forgot to remove it

this is very good format

I found new shit from MS like:
https://i.postimg.cc/mgJZK9MR/regionsettigs-W11.png
it should be OFF
don't be fooled by UTF-8 because it is UTF-65001 ;)

can you define encoding UTF 65001 in VBA ?

if it will be a problem don't worry too much about it %D

thanks for tips but I really want what I want
the result table ONLY ! and nothing more !
your vba will be shorter and easier probably without these bells&whistles

could you explain what it is...

ok, thanks.
I'll test it if I discover how to enable macro in this fucking XL2021 !

Dammed fucking impressive VBA results - this is really NOT necessary !
the result table should be in the same...

// FName
let
Source = Table.Distinct(Table.SelectRows(Excel.CurrentWorkbook(){[Name="FName"]}[Content], each [FName] <> null and [FName] <> ""))
in
Source


// FRegion
let
Source...

this is a big sunflowers
https://d-art.ppstatic.pl/kadry/k/r/1/f4/04/5b86a9b3ca4a8_o_large.jpg

or this
...

if you change filter values you need to right click on the table and choose Refresh

https://i.postimg.cc/9fYZz34M/refresh.png

if it doesn't work you'll need higher version of Excel
---

with...

https://i.postimg.cc/RZV2Fmps/logic.png
each filter filters the values of the remaining rows and not all, only the first filter filters the total (100).
you can test it using only the last filter...

sure, I can tell you but you said long time ago you don't know Power Query

here are two original files (source of data: csv file, result file: xslx file)

path to the CSV file is:...

there is no excel filter , it is just example
as I said I need count rows not see the filtered rows
the result table shows what I want, no less, no more, depending on the filter values used in the...

sure, here is


https://www.youtube.com/@alanelston2330/featured


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
...