I have about 7,500 lines of data in 12 columns. I am trying to extract data based on a number of variable criteria. I can do this by formula but only by blowing the workbook out to 89Mb...
I think the answer lies in =sumproduct or an array formula but I'm failing to get it especially when there are multiple lines of data being returned.
Any help much appreciated.
This thread is marked SOLVED. Did you resolve this (if so how), if not, contact a mod to un-mark it SOLVED
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks