Forum Discussion
How can I return one unique match
Hello I am trying to match participant data for work, based on multiple criteria, and I want it to return me an ID number that has not yet been matched. So far I understand that me using the fol...
=IFERROR(CHOOSEROWS(FILTER($H$2:$H$32,(C2=$I$2:$I$32)*(D2=$J$2:$J$32)*(E2=$K$2:$K$32)),COUNTIFS($C$2:$C2,C2,$D$2:$D2,D2,$E$2:$E2,E2)),NA())This is a small scale example which returns the intended result if i correctly understand the question. The ranges of the formula can be adjusted according to your requirement.
I've highlighted the recurring combinations from columns C, D and E in the screenshot along with their occurrences in columns I, J and K.
Yes!!! Thank you so very much OliverScheurich​