Generate random non-repeated range of numbers?

Hi,

I need to generate a range of numbers in random order without them being repeated, from a specific starting value.

So let's say the starting value was 500...I want to generate a very long cell (not column with each value) containing "500001 | 500007 | 500509 | 500622 | 500398 and so on...it would be from 500000 to 500999.

The reason I need it to be like that is because I'm working with a csv and I need to store this randomized-order range as one large field in the CSV...each line of the CSV contains a different starting value. So I want the CSV to look like this

"500","500001 | 500007 | 500509 | 500622 | 500398 etc."
"400","400409 | 400831 | 400299 | 400005 | 400674 etc."

Any tips/suggestions? I'm using Excel Mac 2008 but I do have access to the PC version at another location where I could do this if need be. Is Excel even the best tool to do this?

Thanks!

Edit: the pipe is just part of the text formatting I want...I wasn't using the pipe to designate a column beginning or anything. The application this is being fed into processes based on the | as the delimiter in that field of the CSV.

You will need to do this on another machine as your best bet would be to use a VBA dependent UDF (not available on Mac2008).

You will find a lot of examples of how to generate (with VBA) a unique random list between two values, your tweak to that code will be to Join the resulting values in the resulting Array of unique randoms into one string with your pipe delimiter as opposed to returning each value to a separate range.

For starters see: http://www.exceltip.com/st/Return_ra...Excel/531.html

if you dont mind a bit of messing around
1, format columns a and b as text
2 in a1 and a2 put 500
3. in b1 put 000 in b2 001
4. in c1 &c2 put =rand()
5 in d1 put =a1&b1 & in d2 put =a2&b2
6.select a1:d2 and drag down to row 1000
7.select data and sort by col C
you now have 500000-500999 sorted randomly in col D
8. open word
9. copy col D and paste special(from the edit menu) as unformatted text
10 in word select all
11.open find/replace
12. replace ^p with " | " (without quotes,assuming you need space either side of pipe) ^p is the paragraph mark from the special characters in word
13. replace all
14. you can now copy/paste all that into a cell (paste special ,text)in excel
15. go back to your random gen sheet find replace 500 in col A with 400
re-sort by col C and repeat process.
it doesn't take long at all in fact it took me longer to write this than do it say 20 times.