Ian Bell
asked on
speed up array formula
Hi,
I would like to speed up the following formula by adding the INDIRECT function if appropriate.
I would also like it to be changed from an array to a normal formula if possible.
refer question 'Speed up Calcs using INDIRECT function'.
Please see attached.
Thanks
index-formula.xlsx
I would like to speed up the following formula by adding the INDIRECT function if appropriate.
I would also like it to be changed from an array to a normal formula if possible.
refer question 'Speed up Calcs using INDIRECT function'.
Please see attached.
Thanks
index-formula.xlsx
File not found
ASKER
oops sorry Saqib, I chose file but forgot to upload it.
now attached.
now attached.
I'm not too sure what you are doing but have you tried a PivotTable?
ASKER
Hi Roy,
Firstly do you understand the formula in column A. If not then we have a problem. All I know is it works.
However far too slow.
I want to add an INDIRECT function to speed it up refer to column E and column M
Firstly do you understand the formula in column A. If not then we have a problem. All I know is it works.
However far too slow.
I want to add an INDIRECT function to speed it up refer to column E and column M
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks all
ASKER
Ejgil, that works great
Thanks
Ian
Thanks
Ian