Remember Me?

#1
October 14th 20, 12:12 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Mar 2020 Posts: 18
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)))

#2
October 14th 20, 12:14 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Mar 2020 Posts: 18
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)))}
#3
October 14th 20, 08:30 AM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,802
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post John Excel Worksheet Functions 6 November 17th 09 07:24 PM chris[_2_] Excel Worksheet Functions 2 June 4th 08 08:51 PM veggies27 Excel Worksheet Functions 8 March 11th 08 07:32 PM M3Cobb[_8_] Excel Programming 2 May 26th 06 04:30 PM Susan Hayes Excel Programming 1 January 7th 05 12:42 AM

All times are GMT +1. The time now is 01:50 PM.