Max Values

S

shebert

Hello
I have a listing of 24 hourly values for each day of the year in Column
B. In column A I have the date/time for the recording hour. I need to
find the 5 highest daily max values and also the values for 5 hours
before and after each peak. Is there a formula or formulae that I can
use to get this information.
Thanks!
 
R

Roberto

YOU MAY USE AN AUTOMATIC FILTER AND THEN PERSONALISE YOUR SORT FOR THE 5 MAX
VALUES
 

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

My calendar keeps returning to working hours of 08:00h to 17:00h even after I set it to 24h? 1
Use a variable in a ShapeRange.Increment 0
Finding location (or start cell) of highest consecutive values 3
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Make peak values move to low value region - Peak Lopping - HELP! 0
Sumproduct Help 3
Help with time function 7
Max/Min per item from a changing list 0

Top