Hi all,
I have the following formula I am using to pull a corresponding date:
=IFERROR(TRUNC(INDEX(ClosedOn,MATCH(A3&B3,ClosedName&ClosedMainAssignee, 0))),"N/A")
My question is this, I have exactly one situation in the subset of data where Ax & Bx are respectively the same twice. The formula is only pulling the first date from the named range "ClosedOn".
How can I modify the formula where it will pull the 1st and 2nd date for each duplciate?
Thanks for any help, I suspect this will be easy for most of you but I can't find a solution myself....
Again, thanks!!~AV
I have the following formula I am using to pull a corresponding date:
=IFERROR(TRUNC(INDEX(ClosedOn,MATCH(A3&B3,ClosedName&ClosedMainAssignee, 0))),"N/A")
My question is this, I have exactly one situation in the subset of data where Ax & Bx are respectively the same twice. The formula is only pulling the first date from the named range "ClosedOn".
How can I modify the formula where it will pull the 1st and 2nd date for each duplciate?
Thanks for any help, I suspect this will be easy for most of you but I can't find a solution myself....

Again, thanks!!~AV