Quote:
Originally Posted by xor
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.
07-26-2017, 06:31 AM
Similar Threads
Excel Formula: return a range of cells that match
Windows 10 
Office 2016
Threaded Mode