Hello,
I have the following formula
SUM(IF(FREQUENCY(IF(ISNUMBER(MATCH($A$1:$G$5000,BR2:BR3,0)),ROW($A$1:$G$5000)),ROW($A$1:$G$5000))=2,1)) would like to add BR4:BR5 in there, and count only if BR2,3,4,5 are in the same row.
For example:
A, D, M, K,
A, B, K, M,
A, C, K, N,
A, D, M, K.
I need A, D, M, K how many times occurs. I do believe the formula can fix it with an upgrade, but just can't figure where to patch it up. If it can't work with 4 conditions, 3 will do as well:
A, D, M,
A, B, K,
A, C, K,
A, D, M.
Thank you in advance!
Bookmarks