Wednesday, January 9, 2013

Excel - generate random sample data file




Some formulas that will help you build sample data files
1.      Random number generation
=RANDBETWEEN(1,1500)
Generates random number between 1 and 1500

2.      Random text generation
=CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))&CHAR(INT(RAND()*26+65))
Generates random text of 3 characters

No comments:

Post a Comment

I would be glad to know if this post helped you.