Formula

you probably need to use a macro to do that.

can you provide a sample of your work so far here?

Pretty easy in Excel to generate random numbers in a range, just use the =RANDBETWEEN(1,10) function for example, generating integers between 1 and 10.  If you want to pull the max value from a cell or VLOOKUP just put that where the 10 is.

That being said, the desire not to repeat duplicates is going to be the tricky one and we may need more info.  Left alone, the function will indeed repeat values, since each random generation is separate from the others, so it's certainly possible to randomly generate the same number multiple times.  To avoid that the prior generated numbers will need to be saved, and then searched on each following attempt, and if the current generated random number was previously generated, then loop to try another randomly generated number.  As mentioned by Ryan this would likely be easiest in a VBA macro function, but would need to fully understand your usage better.

~bp

Attached is a test file. However, the formula is what was given to me . I am not sure what the OFFSET function is actually doing.

Attachment?

~bp

Test.xlsx