+ Reply to Thread
Results 1 to 1 of 1

Formula / Table pulling weekly data to compare daily data

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Los Angeles
    MS-Off Ver
    365
    Posts
    35

    Formula / Table pulling weekly data to compare daily data

    Part 1
    Data in column P / Q is generated once every 5 days
    Once data is generated, every past # from P & Q needs to be compared to the current Hi / Lo in column B / C. When the # is between the range, I want the # from P or Q to appear in column F.
    There will be times when multiple #’s from P / Q are within the Hi / Lo range, but I only need the most recent # to appear in column F.

    Part 2
    The day a # is generated in column F, triggers the analysis of column J / K.
    From this point forward. Each day column J needs to be compared to the current Hi / Lo in column B /C and column K needs to be compared to the current Hi / Lo in column B / C.
    When one of those #’s appears between column B / C that ends that part of the analysis. Then if current close > # from J or K = Up in column I, if current close < # from J or K = down in column I, if inside range = neutral in column I.

    Thank you for your time in getting me going in the right direction. BJW
    Attached Files Attached Files

+ 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] Formula for comparing data from two date ranges, one weekly, the other daily.
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2016, 01:25 PM
  2. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  3. [SOLVED] Formula to Group analytical data imputed daily into daily weekly and monthly analysis.
    By tianasamour in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2015, 06:10 PM
  4. Replies: 1
    Last Post: 04-13-2015, 04:38 PM
  5. [SOLVED] Convert daily data to weekly data using SOME formula
    By Miramira in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2014, 02:14 PM
  6. [SOLVED] Trying to Create a Calendar with Daily and Weekly Data Totals Directly from a Pivot Table
    By guyupstairs in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2013, 12:19 PM
  7. Replies: 3
    Last Post: 10-01-2013, 05:05 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