Results 1 to 5 of 5

Average speed of the 7 machines that start the earliest.

Threaded View

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

    Average speed of the 7 machines that start the earliest.

    Hi I need help with a formula I am creating.

    I want to calculate the average speed given in b2:n2 of the 7 machines that have started the earliest, based on the starttime given in b3:n3.

    I have tried =Average(IF(X36:AJ36<Average(X36:AJ36);X35:AJ35;"")) but when the starttime values are too close together or have major outliers this does not work.

    I have attached a testfile.

    Many thanks in advance!
    Attached Files Attached Files
    Last edited by larsvane; 04-29-2024 at 09:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Speed controls, how to calculate average speed.
    By Hejhallo in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-07-2022, 06:33 AM
  2. Earliest Start Date Ignore Blank Cells
    By MarkCurtis007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2020, 08:33 AM
  3. [SOLVED] Macro to find the Earliest Start Time and Latest Finish Time during a period
    By rehana402003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2018, 06:40 AM
  4. [SOLVED] find earliest start date per person formula/function question
    By webfeet2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2018, 11:25 AM
  5. [SOLVED] Averaging the earliest start times and latest end times for multiple days
    By kbiro in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2016, 02:15 PM
  6. Replies: 2
    Last Post: 06-22-2016, 11:58 AM
  7. Replies: 3
    Last Post: 02-10-2016, 07:26 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