Hi,

I would like to extract the detail available in many rows spread in three columns

Column1 Column2 Column3
Apple aa xx
Banana bb yy
Apple aa yy
Apple aa xx

My question here is what is the formula (Excel function - not filters please) to be used to find how many rows has "Apple" and "aa" and "xx"
The answer should be 2.