You could easily enough do a fill and test sort.
If I were doing it, it'd put the row number into a non-key column ... you
can use =Row() formulas and then copy/paste-values to get rid of the
formulas.
Then I'd construct sort keys using (for instance) the remainder modulo 13,
17, 19, or similar of the row numbers in the key columns.
This wouldn't be a particularly complicated sort, but if it can do a simple
one, it can probably do a hard one.
Regarding size ... it seems to be difficult to break Excel on limits of this
type. However, big spreadsheets are certainly more susceptible to
corruption than small.
I always work on the idea that more than a couple of megabytes of
spreadsheet is starting to ask for trouble.
Indeed, more than a few thousand rows in a spreadsheet shouts "use a
database instead" to me.
Regards, Dave S
----- Original Message -----
From: "Robert E. Carneal" <kentuckygenealogist@gmail.com>
To: "excelvba" <excelvba@yahoogroups.com>
Sent: Monday, January 02, 2012 8:36 AM
Subject: [ExcelVBA] How much text data?
> *How much text data can Excel hold in one sheet? Anyone know?
>
> For an experiment, I tried to fill a sheet with a complicated formulas in
> limits, and it would not do it. (Wow- 65536 * 256 cells of formulas!!! No
> wonder that wouldn't work.)
>
> Could I fill nine columns, from top to bottom, of text information and it
> not fail? Anyway to test that before I actually try it? Only the first
> three columns would be sorted, from low to high. Or is that too much for
> Excel to handle. This is Excel 2000, Windows XP, two gig of memory, and
> two
> terabyte hard drive.
>
> **Thank you.
>
> **Robert*
> *Genealogy without documentation is mythology! Always SOURCE your work.*
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search
> the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1416 / Virus Database: 2109/4116 - Release Date: 01/01/12
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar