View Single Post
 
Old 07-26-2017, 06:31 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 xor View Post
I have attached a file which might be of some interest although it is awfully slow (with about 3500 rows). With 18000 rows as in your Google spreadsheet I guess it will kill Excel completely.

Columns H:M are helper columns.
This is brilliant. Thank you very much! However, I just realized it doesn't provide me with what it is that I ultimately need... the time of days that the x's in Column E refer to. I need to pull the top 30% time of day results, while the x provides the Top 30%, I'd still have to copy and paste the Time of Day into a column.

I'm VERY grateful... I hope this doesn't seem any different to point out I'm still not where I need to be.
Reply With Quote