Or this array formula in C2 and dragged down:Formula:=IF(B2=MIN(IF((TRUNC($B$2:$B$11)=TRUNC(B2))*($A$2:$A$11=A2),$B$2:$B$11)),"x","")
Or this array formula in C2 and dragged down:Formula:=IF(B2=MIN(IF((TRUNC($B$2:$B$11)=TRUNC(B2))*($A$2:$A$11=A2),$B$2:$B$11)),"x","")
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks