Howdy all!
I need to convert this formula to a VBA code
{=MAX(IF(RAW!A:A=Consolidate!A2,RAW!T:T,0))}
My RAW ranges are up to 45,000 records, and the Consolidate sheet is up to 35,000 records, so running that as a formula is quite a slog.
I'm just getting into VBA programming, and don't quite know how to handle this.
Any assistance is much appreciated!
T'is better to run array (or any other formula) on tens of thousands of rows rather than a million plus rows.
Is there a way you can overlay RAW!A:A and RAW!T:T with named dynamic ranges that limit the formulas to consider only rows with real data?
http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks