+ Reply to Thread
Results 1 to 4 of 4

Array Help

  1. #1
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Array Help

    I have spent all night trying to figure this out. As you can tell I know nothing about arrays or how to reference them correctly. Iwould like a "reminder" list to incorporate on the "register" sheet. I've done my best to try and copy and paste and modify the formula to reference my "data" sheet and associated fields, but no success. I've attached both files, the Monthly-Buget is the main worksheet and the Bill-Reminder worksheet. When you open the bill-reminder the arrray pulls data from a table on another worksheet "bills". I want to replicate that on my "Monthly-Household Budget" workbook on the "Register" sheet. I tried copying and pasting the array formula and tried to modify the forumla to meet my needs, but I can't get it to pull my data.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Array Help

    I make reference to cells J6 and M2 in these array formulas (Ctrl+Shift+Enter), for example:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For next two columns I make reference to column J:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    For column M, I made it a little different to result blank, 0 or 1, so your flag works.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    And copy down.

    Please check attachment.

    Good luck!
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-21-2019
    Location
    Topeka
    MS-Off Ver
    2016/Office 365
    Posts
    17

    Re: Array Help

    Thanks, that looks awesome. The dates don't look like they are calculating correctly. Could we modify the formula to look at the numbered day to show the upcoming bills due? Say today is the 27th, what bill will be due in the next 10 days. Use the due date in the data sheet as the base for just the day (not looking at month or year, I am not looking at changing the dates in the data sheet).

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Array Help

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-22-2018, 01:47 AM
  2. Replies: 1
    Last Post: 01-04-2018, 01:07 PM
  3. [SOLVED] Array formulae with different sized array, e.g. array-if() or somproduct-if()?
    By hlhans in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2016, 03:59 PM
  4. Replies: 3
    Last Post: 04-02-2016, 08:16 PM
  5. [SOLVED] Populate one array from another array and print new array as a range
    By Kaden265 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 07:52 AM
  6. [SOLVED] Quick Array question - Copy array to another array then resize?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-02-2013, 01:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1