+ Reply to Thread
Results 1 to 4 of 4

Array formula but with different formula inbetween column

  1. #1
    Forum Contributor
    Join Date
    10-02-2023
    Location
    Singapore
    MS-Off Ver
    Microsoft 365
    Posts
    183

    Array formula but with different formula inbetween column

    Hi, i have 1 tab which is Budget, 1 tab for Actual. Den i have another tab, in this tab, there is a Column for Budget figure by month and a Column for Actual by month and another Column where its actual - budget. However, the Desceiption list might not be same for budget and actual, meaning some appear in Budget but not in Actual. And while the budget's description is fixed, the actual's desciption is not. As n when, new Description might appear.

    Is there a way to do a array formula?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Array formula but with different formula inbetween column

    I could do blocks of 3 columns.

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

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Array formula but with different formula inbetween column

    Another solution:

    The whole table (including thw first column and the headers) in a single cell formula (in one go)

    Please empty all expected results and try:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-02-2023
    Location
    Singapore
    MS-Off Ver
    Microsoft 365
    Posts
    183

    Re: Array formula but with different formula inbetween column

    Hi Hans, your formula is great, but how come the List doesnt include Sales-Ad Hoc from Budget?

+ 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. [SOLVED] Excel Formula to check if the date fall inbetween 2 dates
    By Abdur_rahman in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-25-2023, 01:18 AM
  2. Replies: 4
    Last Post: 10-14-2023, 01:41 PM
  3. Replies: 10
    Last Post: 10-26-2020, 12:18 PM
  4. [SOLVED] Conditional formula to Turn cells white when cell inbetween specific time range
    By ashaw2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-14-2020, 12:24 PM
  5. [SOLVED] Formula to find cell value inbetween two dates
    By UNNI NAIR in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-23-2019, 01:38 AM
  6. [SOLVED] Inbetween formula help required
    By Sue28 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-28-2016, 08:53 PM
  7. Inbetween formula with several variables
    By lhernandez900 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-19-2013, 03:11 AM

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