+ Reply to Thread
Results 1 to 8 of 8

Expand my function for every cell.

  1. #1
    Registered User
    Join Date
    04-25-2020
    Location
    Hamburg Germany
    MS-Off Ver
    2016
    Posts
    4

    Expand my function for every cell.

    Good day,
    I am working on a school project and I am totally new to excel.
    I have a liddle problem by expanding my function.
    I can expand it to the right parts but I canīt expand it on the hole matrix.
    I know I have to change my fixed variables but I have no clue in which format.
    Please see the attached xlsx.
    I could expand the code also into the bottom but i canīt do it for the hole matrix.
    Maybe I need a second request for my second question but why not try it here.
    I would like to have a conditional format. It works perfectly in my sheet but I donīt want to see my values (dates).
    How can i make them invisible? Or format them to the same color like the cell color automaticly?

    Many thanks in advance!

    Kind regards,
    Artem
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Expand my function for every cell.

    Welcome to the forum.

    What's the logic? Without knowing what the formula is meant to do, it's hard to advise.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-25-2020
    Location
    Hamburg Germany
    MS-Off Ver
    2016
    Posts
    4

    Re: Expand my function for every cell.

    It compares the start date with the dates and if it the date is the start date it writes the date down until it reaches the end date.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Expand my function for every cell.

    LOL!!! Well, that's much clearer - thanks.

    I'm really sorry, but I have no idea what you are trying to do, so I can't help.

  5. #5
    Registered User
    Join Date
    04-25-2020
    Location
    Hamburg Germany
    MS-Off Ver
    2016
    Posts
    4

    Re: Expand my function for every cell.

    Have you opened the file I think if you open the file and click on one field where the formula works you will understand

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Expand my function for every cell.

    Yes, of course I have opened the file. How am I supposed to know where you think the formula is working and where you think it isn't? There is a circular reference error - you will need to address this.

    As I said, between the file and your vague description in post #3, I am none the wiser. Sorry.
    Last edited by AliGW; 04-25-2020 at 11:43 AM.

  7. #7
    Registered User
    Join Date
    04-25-2020
    Location
    Hamburg Germany
    MS-Off Ver
    2016
    Posts
    4

    Re: Expand my function for every cell.

    So let me be more specific.
    This is the formula which works look Pic Nr.1Pic1.PNG
    I could expand this formula to all right cells.
    Now i want to expand this to the hole matrix.
    It should look for the "Start" and compare it to each date from cell D3=20.04.20 until BU3=26.06.20
    when it finds the start value so it writes the date down until the end date. It works perfectly for the row 4 and 5.
    but i addad it manually to row 5 but I want it all over the matrix.
    I could manipulate the formula for all Cīs but I canīt expand it to the matrix.
    Look Pic: Pic2.PNG

    Please be so kind and advice me if you need further information.
    Attached Images Attached Images

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: Expand my function for every cell.

    Hopefully someone will understand.

+ 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: 3
    Last Post: 04-25-2020, 09:46 AM
  2. How to expand index function
    By go_sparty in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2013, 09:56 AM
  3. Replies: 2
    Last Post: 04-27-2010, 12:06 PM
  4. [SOLVED] How do I expand Excel lookup function to search more than 16,384 r
    By Rusty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2006, 05:35 PM
  5. HOW CAN I EXPAND A RANGE IN A FUNCTION BEYOND 30 CELLS IN EXCEL?
    By excelfriendwannabie in forum Excel General
    Replies: 2
    Last Post: 03-16-2006, 12:40 PM
  6. how to expand sort function beyond 3 on excel
    By Rewbs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2006, 09:50 AM
  7. [SOLVED] Using the balance sheet template, any way to expand?-way to expand
    By RABBITS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2005, 02:05 PM

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