I have a spreadsheet that multiple match criteria has to be done. How can I do this
I want to put the value "ADJ" in column D when:
ID is the same
The ID has a C1 and C5 proc
proc of c1 and c5 are equal
I tried with countifs, but I am missing the piece that would match the respective values in column C when all else is true
In this case line 16 meets the criteria
Line 16 is false because the value of C8 does not match the value of C9 even though all else is true.