Express Array Function as VB
 

Hi Team

I was hoping someone could assist by translating this function to VB please.

As always, TIA.

Mark.

=MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A5 ,Data!$G$2:$G$250)))

Express Array Function as VB
 

Formula should have been

{ =MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A5 ,Data!$G$2:$G$250)))}

Express Array Function as VB
 

Hi Mark,

Am Tue, 13 Oct 2020 16:14:25 -0700 (PDT) schrieb NoodNutt:

Formula should have been

{ =MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A5 ,Data!$G$2:$G$250)))}

no need to translate it. You can take it as it is.
E.g.:

Range("C1").FormulaArray = _
"=MIN(IF(Data!$I$2:$I$2500,IF(Data!$B$2:$B$250=$A 5,Data!$G$2:$G$250)))"


Regards
Claus B.
--
Windows10
Office 2016

Express Array Function as VB
 

Hi Claus

A big apology for my tardy response.

After trawling some more through Dr. Google, I manage to find the answer.

Take care

Warm regards
Mark.