I am trying to summarise recurring blocks of data which occur at regular iteravals within 100,000 lines of data. Each array contains the costs by cost code (up to 30)and properties (2,000). Help! I have attempted indexation and =mod but I'm not even coming close.
Any help very much appreciated - a data sample spreadsheet is below.
So you are not trying to summarize data, but process and standardize it correct?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
See if this is what you're looking for.
David
(*) Reputation points appreciated.
Thanks David
I have just run out of resources trying to do it using array formula. Your solution looks great - I will try it now on the sheet and get back to you.
Hi David
That is awesome. I am working my way through the VBA to see how it all works but it's brilliant. Thank you - I will be able to enjoy my weekend now! Much reputation added.
That's great! Glad it worked out for you.
How long does it take to run on 100,000 lines?
Can you post the code in the forum and provide the comments so we can understand what is going on?
Sure. I was debating on whether to do that or not.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks