In this example, I need to filter records in the last column (AK) by zero or one...easy. In small datasets, I can simply copy & paste the filtered dataset into a new workbook and save it as CSV (copy just the zeros in one workbook and the ones in a 2nd workbook). In large datasets (up to 60,000 rows) copy & pasting won't work. I've looked around for a solution to how to save the filtered set but haven't found anything yet. I'd appreciate any help you can offer. Thanks!
May I ask how come copying and pasting 60,000 rows into a new workbook doesn't work? If you are pasting them as values into a new workbook i would expect it not to take that long to process. I personally have done this with over 125,000 rows and ~50ish columns at once before without there being any kind of hiccups.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Excel crashes or takes 20 minutes to paste
I would think adding formulas to grab these 60,000 rows would bog down your computer even more than copying and pasting them. My best guess would be to hold left click on the tab and then hold CTRL as well and drag to the right. This iwll make a copy of the tab. Repeat this process again. Then in one of the new tabs filter on 0's and delete them all. On the other tab filter on 1's and delete them all. Now you have two tabs one with 0's and one with 1's. click on one of the tabs and save as .csv. then click on the other tab and save as .csv
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks