Mode between two serial dates/times

  • Thread starter Thread starter ChrisM
  • Start date Start date
C

ChrisM

Hi all,

I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
serial format).

The second spreadsheet contains two columns. One containing a serial
date/time and the other containing a meteorological value (eg. temperature).

I want Excel to read the start and stop date/time from the first spreadhseet
and then search the second spreadsheet for all temperature values which were
recorded during this time frame.

Lastly, I want Excel to determine the MODE of these values.

Is this possible using a single Excel function?? Or will I have to use many
nested functions?? Would it be easier to use VBA and if so where would I
start?? Any help would be greatly appreciated. Thanks

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mode Between Two Serial Dates/Times 1
averaging a value between two serial dates 1
formatting a spreadsheet help 4
countifs Function not giving desired result with date criteria 2
Difference between NOW() and TODAY() 9
Keyboard shortcut for current date and time 1
Date and Time Conversion 3
MATCH FUNCTION AND SERIAL DATE CONFLICTS 4

Back
Top