All,
Long time listener, first time poster. I was wondering if anyone could help me with the below predicament.
Excel 2010
I have a countifs function that is working perfectly.
1
=COUNTIFS('Risk & Control Repository'!H9:H9624, O7, 'Risk & Control Repository'!$W$9:$W$9624,CONCATENATE($D$13,E$16))
However, I want to add one more criteria to it.
2
=COUNTIFS('Risk & Control Repository'!H9:H9624, O7, 'Risk & Control Repository'!$W$9:$W$9624,CONCATENATE($D$13,E$16), THIS COLUMN, ISUNIQUE)
i.e.
1) will return duplicated rows
2) will not as THIS COLUMN is a unique identifier.
I want to return all unique rows based on the unique identifer that meet the other criteria.
Any and all help would be very much appreciated.
Bookmarks