Quote:
Originally Posted by Pecoflyer
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.