Need help with random number generator

[daniel_dani95]

Hello,

I'm working on some sort of quiz and I want to generate some amount of random numbers (specifically 80) which will represent question that is in cell with that number and then excel will over VLOOKUP find and display that question. I have question bank of 2500 questions. I found through this site that I can use RANDBETWEEN function to generate random numbers and then this,

=1+RANK.EQ(B2,$B$2:$B$81)+COUNTIF($B$2:B2,B2)-1

, in another column to make numbers unique.

My problem is that when generating unique numbers, RANDBETWEEN function gives numbers in range from 1-2500 but the other function give only numbers up to 80, never above, let alone 2500.

What did I do wrong?

Thanks for help in advance

 

[Fluff]

How about

=TAKE(SORTBY(SEQUENCE(2500),RANDARRAY(2500)),80)

This will return 80 distinct numbers from 1 to 2500

 

[daniel_dani95]

How about

=TAKE(SORTBY(SEQUENCE(2500),RANDARRAY(2500)),80)

This will return 80 distinct numbers from 1 to 2500

Thank you very much, this is simpler than the thing i did

 

[Fluff]

You're welcome & thanks for the feedback.