First Random
=INDEX({27;28;29},RANDBETWEEN(1,3))
Second Random
=SMALL(INDEX(({27;28;29}<>C11)*({27;28;29}),0,0),RANDBETWEEN(2,3))
Last
=SUMPRODUCT(({27;28;29}<>C11)*({27;28;29}<>E11)*({27;28;29}))
First Random
=INDEX({27;28;29},RANDBETWEEN(1,3))
Second Random
=SMALL(INDEX(({27;28;29}<>C11)*({27;28;29}),0,0),RANDBETWEEN(2,3))
Last
=SUMPRODUCT(({27;28;29}<>C11)*({27;28;29}<>E11)*({27;28;29}))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks