I have an excel table like this which contains Name and Date as shown below. I want to find out the lowest and highest date based on Name on right side.The right table already contains the Name. I want to get their lowest and highest date based on Name

The final result should be like this

What should be the formula to get this result ?

CodePudding user response：

In cell E2, copied right to F2 and all copied down :

=AGGREGATE(15-(COLUMN(A1)=2),6,$B$2:$B$9/($A$2:$A$9=$D2),1)

CodePudding user response：

Cell E2 = =MINIFS($B$2:$B$9,$A$2:$A$9,D2)

Cell F2 = =MAXIFS($B$2:$B$9,$A$2:$A$9,D2)