Boards
Excel-lent question!
One column contains text data, as does the column next to it. I need a formula that tells me how many times column A=x and column B=y. I have little to no experience of IF, AND and OR.
Pivot table shmivot table, I need a formula.
Cheers