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.
Bookmarks