Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,341
Dear friends,
I have a formula =INT(RAND()*100000000000)*100+ROW(). When I press F2 > F9 I get a result shown in curly brackets in the formula evaluation space.
1. What do the curly brackets mean?
2. I want to use RANK() on the numbers. Is there a better way of getting more or less random numbers which cannot ever be duplicated in a column (Max rows 99)?
I have a formula =INT(RAND()*100000000000)*100+ROW(). When I press F2 > F9 I get a result shown in curly brackets in the formula evaluation space.
1. What do the curly brackets mean?
2. I want to use RANK() on the numbers. Is there a better way of getting more or less random numbers which cannot ever be duplicated in a column (Max rows 99)?