??? 10.png
I used the formula -->=COUNTIF(A:A,"*"&C1&"*")
I want Aggregate function or other formula
??? 10.png
I used the formula -->=COUNTIF(A:A,"*"&C1&"*")
I want Aggregate function or other formula
Last edited by chief_abound; 11-03-2015 at 12:29 AM.
AGGREGATE works with "real array" that exists in worksheet,i.e A1:A8
did not work with "virtual array" likes FIND(C1,A1:A8)
With given example, SUMPRODUCT(ISNUMBER(FIND..)) or COUNTIF is properly solution.
Quang PT
Hi! bebo021999
Oh, I see what you're saying. Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks