|
Re: The best elegant solution to override 65k rows limit in a sheet
aaron.kempf@gmail.com wrote...
....
>I mean seriously-- with a couple of queries; a couple of macros and a
>little bit of time-- there ins't anything in the world that you can't
>calculate with Microsoft access.
....
Gosh, with a few formulas, a couple of macros and a bit of time I could
do anything in Excel you could do in Access *WITH* *SMALL* *DATASETS*.
I could even think of a few things that would be much easier in Excel.
(I already have - have you made any improvements to the queries I
proposed for amotization tables in
http://groups-beta.google.com/group/...e=source&hl=en
or http://makeashorterlink.com/?S1402436B ?)
Next, without using Excel directly, calculate the 90th pecentile from
the Beta distribution with alpha = 0.5 and beta = 2.5. [Though some
versions of Excel don't do such a wonderful job with stuff like this.]
|