Forum Discussion
HOW TO: Use ADDRESS within COUNTIFS
I have a file like the one attached. I am trying to get the formula: =IF(COUNTIFS(A4:F4,"*"&A2&"*",A4:F4,"*"&B2&"*")>=1,":D",":c") To return the cell address where the statement is true (instead...
oh, I am sorry, I am editing the original post to reflect what I am actually trying :)
Two files with different setups.
It is still not clearer.