Bored at work? Make some nuz...
DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact | Forum

sorting by color of 300,000 record file not working

View: New views
1 Messages — Rating Filter:   Alert me  

sorting by color of 300,000 record file not working

by robroth :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have a 300,000 record file and used Excel 2007's built in conditional formatting feature to color duplicate cells.  I then need to find the duplicates, so I want to sort the cells by color so I'm not scrolling through 300,000 records looking for red cells.  However after installing this application and choosing to sort my column by color, I just watch Excel sit there.  In fact my CPU monitor doesn't even show all that much going on on any of my 4 CPUs.

Is something wrong with the way this is working on my system, or does this product not handle sorting in the same speedy manner as the built in Excel sorts?  If I were to sort by a built in criteria, Excel can sort the 300,000 records in about 3-4 seconds.

Thanks!
LightInTheBox - Buy quality products at wholesale price


Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.