ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to use excel or access to do the drawing price for customer (https://www.excelbanter.com/excel-discussion-misc-queries/168163-how-use-excel-access-do-drawing-price-customer.html)

alex the new IT guy

How to use excel or access to do the drawing price for customer
 
my company is going to hold an event which will give away prices for
customer. how do we use excel or access to dothe drawing templete? i have
both office 2003 and 2007.

Bernard Liengme

How to use excel or access to do the drawing price for customer
 
Have a look at =RANDBETWEEN(1,1000)
If you get a #NAME! error, try =INT(RAND()*1000)
Both give a random number in the range 1 to 1000
To get a series of random numbers with no duplicates see
http://www.mcgimpsey.com/excel/udfs/randint.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"alex the new IT guy" <alex the new IT wrote
in message ...
my company is going to hold an event which will give away prices for
customer. how do we use excel or access to dothe drawing templete? i have
both office 2003 and 2007.





All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com