Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I access customer information easily on XL? | Excel Discussion (Misc queries) | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
base price list compute on to another price list? on excel work sh | Excel Discussion (Misc queries) |