Ensure random number generation (from range) without duplicates

[RichieRidge]

I need random number generation within a range using rank.eq. As per attached, I have RANDBETWEEN at M5 generating random number between value in I5 and J5. I then have rank.eq in col N to ensure random number generation without duplicates. The formula works perfectly when I manually enter the range (G2:G8 in this example). I want to replace the manually entered G2:G8 with the contents of cell D5 which contains the text G2:G8. Entering all the ranges manually is not practicable so I need to dynamically bring in the range criteria.

 

[p45cal]

cross posted at

https://www.reddit.com/r/excel/comments/qls31w

 

[vletm]

RichieRidge
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences, if someone would use Cross-Posting.
Those rules are for You too.