Randbetween excluding given list - Question paper preparation

Hello Friends

I need to extract the number randomly from given list (A1:A50) and excluding in list (light pinkC4:D8) and need to plot in light yello cells E4:E8.

This is for question paper preparation, the intension is previous time asked questions should not repeat.

thanks in advance

or can try
F4=INDEX($A$1:$A$50,SMALL(INDEX(COUNTIF($C$4:$D$8,$A$1:$A$50)*10^10+COUNTIF($F$3:$F3,$A$1:$A$50)*10^10+ROW($A$1:$A$50),0),RANDBETWEEN(1,50-COUNT($C$4:$D$8)-COUNT($F$3:$F3))))

Please Login or Register  to view this content.

Try this and copy towards down

Hello Phuocam & Siva

Thanks for this formula which is working well and saves manual work.

Thanks again.