+ Reply to Thread
Results 1 to 4 of 4

Time series result based on cerain criteria

Hybrid View

  1. 03-17-2025, 08:02 AM #1
    mixers99
    mixers99 is offline
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    18

    Talking Time series result based on cerain criteria

    Hi all.

    I have a time series in column A, a condition in column B and result in column C. If a condition in column B is greater than -50, then result in column C should be equal to column A. However, if criteria in column B reaches -50 or below, then result in column C is 10 times greater than in column A. Now comes the hard part: next cells in column C should also give a result that is 10 time greater than in corresponding cell in column A until critera in column B reaches 0. I've made an example in a sheet and desired result in column C.

    Your help is greatly appreciated!
    test2.xlsx
    Reply With QuoteRegister To Reply
  2. 03-17-2025, 09:09 AM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,910

    Re: Time series result based on cerain criteria

    The following formula returns the values posted in column C:
    Formula: copy to clipboard 
    =IF(IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1<=-50),1),0)>IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1=0),1),0),A1*10,A1)

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 03-17-2025, 08:01 PM #3
    mixers99
    mixers99 is offline
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    18

    Re: Time series result based on cerain criteria

    Thank you so much for your help!
    Reply With QuoteRegister To Reply
  4. 03-17-2025, 08:30 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,910

    Re: Time series result based on cerain criteria

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [SOLVED] Macro to retain cerain Data in Col A
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2021, 12:19 AM
  2. [SOLVED] Weighted Average of Sequential Time Based Data Series Using Start/End Time Input
    By marcoyul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2017, 12:10 PM
  3. Need formula to count score based on criteria (0/1 variable, time series)
    By wintheranders in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2015, 07:08 AM
  4. Need formula to count score based on criteria (0/1 variable, time series)
    By wintheranders in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2015, 04:57 AM
  5. Cut and paste an entire row to another sheet if a cerain criteria is met
    By julia_helena in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2014, 01:53 PM
  6. Charting time series based on different scenarios
    By _keith in forum Excel General
    Replies: 7
    Last Post: 01-08-2011, 06:41 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