Скачать или смотреть Creating Random Data in Excel using RANDBETWEEN and CHOOSE

https://excel.tv/creating-random-data...

Jordan gives some tips for creating random categorical data in Excel. His tip includes use of the RANDBETWEEN() and CHOOSE() functions. Oz gives this 4 srirachis.

The panel then discusses the practical uses of this tip for creating dashboard mockups and creating tons of dummy-data on the fly.

Excel TV
SUBSCRIBE:    / exceltvshow  
Google Plus: https://plus.google.com/1165330821322...
Facebook:   / exceltvseries  
Twitter:   / exceltv  

Our Personal Sites:
Website
Rick Grantham: http://rickgrantham.com/
Jordan Goldmeier: http://optionexplicitvba.com
Oz Du Soleil: http://datascopic.net

Youtube:
Oz Du Soleil:    / walruscandy  
Rick Grantham;    / mrrickgrantham  

Facebook:
Rick Grantham:   / authorrickgrantham  
Jordan Goldmeier:   / optionexplicitvba  
Oz Du Soleil:   / devilhorse  

Google Plus:
Oz Du Soleil:
Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier
Rick Grantham: https://plus.google.com/+RickGrantham

LinkedIN:
Jordan Goldmeier:   / jordangoldmeier  
Oz Du Soleil:   / ozdata  
Rick Grantham:   / rickgrantham  


Twitter
Oz Du Soleil:   / oz_dragoncookie  
Rick Grantham:   / bistrategyguy  
Jordan Goldmeier:   / option_explicit  

Products:
Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/

Jordan - Excel Consulting & Training
http://www.GoldmeierConsulting.com
http://www.ExcelAndAccess.com
http://www.VBAExpress.com