Hi Guys,
I have hard time figuring out counting certain texts that is including "AB-01" with filter on, any texts that including "AB-01" so i applied "*"&"AB-01"&"*" but i know formula is not enough
this is what i tried; '=SUMPRODUCT(1/COUNTIF(C3:C17, "*"&"AB-01"&"*"))'
especially when when specific text appears more than once in one cell..
also the specific text appears more than once, i do not want the formula to count the duplicate text
lastly, it should recognize the filter effect and adjust the number of count
i have attached the excel file to help you understand the problem
greatly appreciate for your help..
Bookmarks