Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuff
Pages
▼
Thursday, February 20, 2020
Generate Random Numbers in Power Query
Want to create random numbers in Excel? If you're familiar with RAND and the RANDBETWEEN functions, did you know there was an equivalent in Power Query where you can create a list of random numbers in each row. There's no command icon to click in Power Query, so you'll have to go into the M language (but it's fairly easy).
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.