Otherwise can with new dynamic formulas. =COUNTA(UNIQUE(FILTER(A1:A15,BYROW(A1:A15,LAMBDA(x,MAX(COUNTIFS(x,{"Unknown","Multiple","*USD*"})))=0))) Harun24HR thank you sir, i tried your method but showing: did I do sth wrong? so the school list name ranges from **...
Many thx in advance! Hi, all I have a question to ask for a formula I plan to use in excel: this is my situation: 1. in E column, we have 10k rows of different school name normally end with school, high school or mid... Deleted If you have Microsoft 365 or Office...
Many thx in advance! Hi, all I have a question to ask for a formula I plan to use in excel: this is my situation: 1. in E column, we have 10k rows of different school name normally end with school, high school or mid... Deleted ...
2. I planned to use sumproduct formula to know the unqiue value of all school name (also excluding name such as: unknown, Multiple, or USD xxx - Unknown. Normally I use remove duplicates to calculate the unique value, but this time I planned to use f...