Results 1 to 4 of 4

Convert Array formula to MACRO/VBA

Threaded View

  1. 02-18-2020, 05:53 AM #1
    acerlaptop
    acerlaptop is offline
    Registered User
    Join Date
    10-21-2014
    Location
    Makati
    MS-Off Ver
    MS365
    Posts
    74

    Convert Array formula to MACRO/VBA

    Hi everyone,

    I have a Array formula that I wan't to convert to Macro/VBA.

    Is it possible??

    {=IFERROR(INDEX(DATA!$F$3:$F$15000, MATCH(0,IF(DATA!$A$3:$A$15000=$A$1,COUNTIF($M$46:M46, DATA!$F$3:$F$15000),""), 0)),"")}
    Last edited by acerlaptop; 02-18-2020 at 06:09 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Array Formula to Non-Array
    By Gazsim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2019, 10:56 AM
  2. Convert Array MAX formula to VBA
    By theTaoJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2018, 04:16 PM
  3. [SOLVED] Convert this array formula into VBA?
    By vpan in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-09-2016, 06:55 PM
  4. Convert array formula to VBA
    By nthnothing in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2015, 10:23 PM
  5. [SOLVED] Convert array formula to vba
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2015, 03:10 AM
  6. Macro to convert string into array
    By mithil in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-11-2010, 03:29 PM
  7. [SOLVED] convert excel data to 2-D array using macro
    By David in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-13-2005, 10:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1