I created a UDF below which is expected to work nicely. The idea is to calculated weighted average for a variable (cases need to meet the criteria). But when the range contains 50,000 rows (e.g. A1:A50000), this macro is just dead. Excel just keeps running for hours after hours without responding. I thought array in VBA is quick enough to handle 50,000 rows. I am wondering if there is a better way to do calculation when there are so many rows used.
Please Login or Register to view this content.
Bookmarks