How to find the lowest and highest date based on certain value in another column?
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 ?
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)
Cell E2 = =MINIFS($B$2:$B$9,$A$2:$A$9,D2) Cell F2 = =MAXIFS($B$2:$B$9,$A$2:$A$9,D2)