Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 08:17:10 +0000

How to Post a Message for Support

Post From: Excel error & GetCorrespondingMatch multiple criteria selection

[2016-08-10 18:34:38]
[Go To First Post]
User025902 - Posts: 8
OK sorry for the delay, here is how I overcame the issue:

I used Rows AA+ for the array Excel function so the chart update wouldn't convert the formulas to standard format. Then I used regular formulas for the charting rows with arguments from those array functions.

The only problem now is the speed - it takes a whole minute for the tab to recalculate.