+ Reply to Thread
Results 1 to 6 of 6

Return a date if on that date a value in a column becomes greater than the next column

  1. #1
    Registered User
    Join Date
    10-30-2020
    Location
    Den Bosch, Netherlands
    MS-Off Ver
    365
    Posts
    7

    Return a date if on that date a value in a column becomes greater than the next column

    I am making an excel sheet to keep track of finances.

    Column A: date
    Column B: savings
    Column C: debt

    I keep track of when the interest is added to the debt.
    I also keep track of when the interest is added to the savings and when a deposit is made on the savings account.

    I want to have a formula that gives me the exact date (column A) that the savings (column B) is higher than the debt (column C)

    I was thinking of a combination of index and match. However I have very little experience with this, can someone please help me?
    Attached Files Attached Files
    Last edited by larsvane; 02-08-2024 at 08:23 AM.

  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,916

    Re: Return a date if on that date a value in a column becomes greater than the next column

    There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
    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
    10-30-2020
    Location
    Den Bosch, Netherlands
    MS-Off Ver
    365
    Posts
    7

    Re: Return a date if on that date a value in a column becomes greater than the next column

    Hi Thanks Ali, I forgot to add it. Now it should be attached.
    Last edited by AliGW; 02-08-2024 at 07:46 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  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,916

    Re: Return a date if on that date a value in a column becomes greater than the next column

    Try this:

    =TAKE(FILTER(B2:B21,E2:E21>C2:C21),1)

  5. #5
    Registered User
    Join Date
    10-30-2020
    Location
    Den Bosch, Netherlands
    MS-Off Ver
    365
    Posts
    7

    Re: Return a date if on that date a value in a column becomes greater than the next column

    Thank you Ali, this works perfectly. I will close this thread.
    Last edited by AliGW; 02-08-2024 at 08:31 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  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,916

    Re: Return a date if on that date a value in a column becomes greater than the next column

    Glad to have helped.

    If you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

+ 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] sort values in column if date in another column is greater than referance cell
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2023, 10:50 AM
  2. Make a column=zero when date the is greater than a specific date
    By Megatronv in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-14-2021, 01:15 PM
  3. [SOLVED] getting total from column if todays date is equal to or greater than date column
    By peterjb44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2013, 07:43 PM
  4. If hire date (column D) is greater than revision date (column F) then delete row
    By bruinsrme in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2013, 07:25 PM
  5. [SOLVED] Match Date (Column A) and add all value (Column D) for that date, return one value
    By Britte in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2013, 09:05 PM
  6. Select a Date between Two Date Rows, then the Column State and return Table Matrix Values
    By InNeedofHelpASAP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 11:03 AM
  7. Replies: 5
    Last Post: 10-14-2010, 01:06 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