+ Reply to Thread
Results 1 to 6 of 6

Calculation between two non sequential rows

  1. #1
    Registered User
    Join Date
    08-12-2021
    Location
    Michigan
    MS-Off Ver
    version 2017
    Posts
    12

    Calculation between two non sequential rows

    I have two wells that get a meter reading during the month. The readings will not be on consecutive days each week, nor on the same day of the week. Is an index formula the best to calculate the difference between the two readings? I then need to calculate the difference in the two reading to get the gallons per minute. I want to put a formula in there so that no matter which day of the of month the meter readings are taken, it will calculate the numbers. This is being used by field operators with no excel experience. trying to make it easy for them. thx.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Calculation between two non sequential rows

    What is it that you're calculating in C6 and E6?
    If well1 ran for 2430.6 hours and it's rate was 175 GPM, you want the number of gallons (div. by 1 million.)?
    If so,
    Please Login or Register  to view this content.
    yields 25.521 million gallons.
    Copy down. Same with E6 (change 175 to 125).

    Pete
    Last edited by PeteABC123; 07-10-2023 at 03:52 PM.

  3. #3
    Registered User
    Join Date
    08-12-2021
    Location
    Michigan
    MS-Off Ver
    version 2017
    Posts
    12

    Re: Calculation between two non sequential rows

    I made some notes on my example. I need to calculate the time difference within the meter column. I then will calculate the gpm based on the hours converted to minutes. It's calculating the time in a formula that can run down the column. I may be overthinking. thx.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,572

    Re: Calculation between two non sequential rows

    I don't see any notes in the example, nor do I see any manually calculated results to go by, so this is guesswork.
    The following formula placed in cell C5 and copied down will result in 308.00 in cell C17:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    When the formula is copied over to cell E5 it becomes:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    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.

  5. #5
    Registered User
    Join Date
    08-12-2021
    Location
    Michigan
    MS-Off Ver
    version 2017
    Posts
    12

    Re: Calculation between two non sequential rows

    That is amazing! It works. Thank you so much.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,572

    Re: Calculation between two non sequential rows

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Match every two sequential rows
    By Yorker in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2014, 08:58 AM
  2. [SOLVED] Match Sequential rows
    By Yorker in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2014, 08:52 AM
  3. Paste into non sequential rows
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2012, 01:15 PM
  4. How to copy sequential vales into non sequential rows
    By dchalem in forum Excel General
    Replies: 11
    Last Post: 01-18-2011, 12:19 PM
  5. How to automate a repetitive calculation on 3 sequential cells
    By Excel4Lab in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-09-2010, 04:23 PM
  6. Search Sequential Rows
    By PBROW in forum Excel General
    Replies: 2
    Last Post: 06-15-2010, 12:54 PM
  7. Sequential numbering and Rows
    By mkarylyle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2008, 05:54 PM

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