Re: How to generate a list of prime number?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hello,

Why don't you just store the first 65536 primes in a worksheet and
look them up later (see: http://primes.utm.edu/)?
At a little cost of storage space you can gain some speed ...

Regards,
Bernd

.



Relevant Pages

  • Re: excel tables
    ... Nick Hodge ... On sheet1 I entered some values in A1:A3 ... > Worksheet 2 - In this worksheet I want to be able to pick from the> parts ... > enter in quanties and have the cost added up accordingly. ...
    (microsoft.public.excel)
  • Re: excel tables
    ... I have XL2007 installed and can see no difference between the functionality of DV in 2007 from 2003. ... > Worksheet 2 - In this worksheet I want to be able to pick from the> parts ... > enter in quanties and have the cost added up accordingly. ... >>> Window item, Cost of window, cost of screen, cost of grill. ...
    (microsoft.public.excel)
  • Re: excel tables
    ... I have just installed Office 2007 and have been playing with XL2007. ... type a straightforward range address on another sheet or in another ... UNIT COST SCREEN GRILLES ... Worksheet 2 - In this worksheet I want to be able to pick from ...
    (microsoft.public.excel)
  • RE: How to split and consolidate sheets into new workbooks
    ... is the same or at least A in workbook 1 is equal to A in workbook 2, ... Go through each worksheet and gather the nameof the cost centres. ... Again deal with cells that have greater than 255 characters. ...
    (microsoft.public.excel.programming)
  • Re: excel tables
    ... If you give the list a name and then refer to the name you can use a list from another sheet, select the list, in the name box above A1 type the name and press enter or do insert>name>define. ... UNIT COST SCREEN GRILLES ... Worksheet 2 - In this worksheet I want to be able to pick from the parts table ... Window item, Cost of window, cost of screen, cost of grill. ...
    (microsoft.public.excel)