Support Board
Date/Time: Wed, 29 Oct 2025 20:38:30 +0000
Post From: Excel error & GetCorrespondingMatch multiple criteria selection
| [2016-08-10 18:34:38] |
| 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. |