• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ensure random number generation (from range) without duplicates


New Member
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.



Excel Ninja
You should reread Forum Rules
There are clear sentences, if someone would use Cross-Posting.
Those rules are for You too.