Macro which replace large array formula

**ALEZI** · 04-19-2014, 05:58 AM

Hello all

I have a large array formula in my files,can i somehow change my big formula by macro.

Please see my attached sample,im ready to learn how to do this.

Thank you in advance.

**RudiS** · 04-19-2014, 07:36 AM

Hi,

Here is the formula (exactly as specified in your sample file), as a macro instruction.
It will apply the formula to cell B4.

Please Login or Register  to view this content.

**ALEZI** · 04-22-2014, 02:32 PM

Thank you for the answer,but Macro instructions didn't work fine (see attached sample).
In MATCH function range is not correct after run Macro.

If i understood correct this Macro sub insert array formula in cell B4,can you write Macro instruction which same things as array formula,not only insert this formula or can you give mi some directions for thinking

.

Also,i need to implement this instructions in whole B column,not only in B4.

Thank you in advance...