View Single Post
 
Old 07-25-2017, 05:50 AM
FarStar FarStar is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2017
Posts: 10
FarStar is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
An Excel worksheet
Ah... thank you. Here goes.

https://docs.google.com/spreadsheets...it?usp=sharing

Ultimately, I'm trying to figure out what time of day is the most likely to have the highest prices. I conditional formatted my private file to show me the top 30% of each day, yet I have to then manually copy the adjacent time of day into the D column and that takes a long time for five years of data. I figured an X or True or something similar in D would allow me to sort D and get the times of day I want. Hope this makes sense.
Reply With Quote