Try:
copied down.![]()
=IF(OR(B2>SMALL($B$2:$B$25,5),AND(B2=SMALL($B$2:$B$25,5),COUNTIF($B$2:$B$25,SMALL($B$2:$B$25,5))>1)),".",A2)
Try:
copied down.![]()
=IF(OR(B2>SMALL($B$2:$B$25,5),AND(B2=SMALL($B$2:$B$25,5),COUNTIF($B$2:$B$25,SMALL($B$2:$B$25,5))>1)),".",A2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks