|
Just FYI, I tried the workbook with 5900 rows and it worked fine -- I filled all the columns down, not just the non-blank ones (A:D and F:O).
Here's what to do:
delete the sample addresses that are already there.
switch to manual calculation (Tools-->Options-->Calculation-->Manual (and no calculation on re-save) --> OK
highlight first row of formulas (row 3) all the way across from A:O
copy
highlight cell A4
drag the slider bar on the right of the screen all the way down to row 5900 or so (you can go a little past what you need-- remember there are two header rows in this workbook)
hold down shift and highlight cell O5900
this will highlight the whole block
press Cntrl-V to paste
this will take your computer at least several seconds to copy all the formulas down
paste in your addresses under the green header
make sure the formulas go down far enough (there should be a warning in cell B1 if not)
hit F9 to do the calculations
on my computer, it took about 7 minutes to do the calculations after pressing F9; you should be able to see the progress in the lower left of the screen.
copy & paste special to another sheet
sort everything but the header row DESCENDING (the blanks will go to the bottom.
you're done
delete the formulas except row 3 before saving or you will have a MASSIVE file
|