Thread: Applying random changes to a list of numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions
[email protected] greg.jobs@yahoo.com is offline
external usenet poster
  
Posts: 12
Default Applying random changes to a list of numbers
Using excel, if I have a list of numbers

e.g.
1000
2223
2448
1229
3883
2238
4488
2388

etc.


Is there a way to do it
- Generate a random number between 0 and 10
- If number is greater than 7 then change the number so that the last
digit & the second last digit are tranposed (e.g. 2448 becomes 2484)

Reply With QuoteReply With Quote