=SMALL(IF(ISNA(MATCH(COLUMN($A$1:INDEX($1:$1,5)),$B2:B2,)),COLUMN($A$1:INDEX($1:$1,5))),RANDBETWEEN(1,5-COUNT($B2:B2)))
confirmation of post2
=SMALL(IF(ISNA(MATCH(COLUMN($A$1:INDEX($1:$1,5)),$B2:B2,)),COLUMN($A$1:INDEX($1:$1,5))),RANDBETWEEN(1,5-COUNT($B2:B2)))
confirmation of post2
Last edited by tim201110; 11-27-2017 at 03:11 PM. Reason: bad english
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks