Lottery function - how to randomly select cells
how to create function to randomly select names
|
Lottery function - how to randomly select cells
With the Analysis ToolPak add-in activated (tools-addins):
Cell address in range A1:Z1000 =ADDRESS(RANDBETWEEN(1,1000),RANDBETWEEN(1,26),4) Press F9 to generate a new random address. If you want the contents of that cell: =INDIRECT(ADDRESS(RANDBETWEEN(1,1000),RANDBETWEEN( 1,26),4)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "ap@rfr" wrote: how to create function to randomly select names |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com