Posted to microsoft.public.excel.programming

NoodNutt[_2_] NoodNutt[_2_] is offline

external usenet poster

Posts: 39

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)))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Function for different array	John	Excel Worksheet Functions	6	November 17th 09 06:24 PM
Array / Function HELP!!!	chris[_2_]	Excel Worksheet Functions	2	June 4th 08 08:51 PM
OR function in array-entered IF function	veggies27	Excel Worksheet Functions	8	March 11th 08 06:32 PM
Three way array function	M3Cobb[_8_]	Excel Programming	2	May 26th 06 04:30 PM
How to express a cell address into numeric for array use	Susan Hayes	Excel Programming	1	January 6th 05 11:42 PM

All times are GMT +1. The time now is 02:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us