Google Spreadsheet Post #1295
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 20, 2013
user post by Aaron Issacs (http://productforums.google.com/forum/?zx=cxfn6lem6psg#!searchin/docs/InOverMyHead/docs/2xTx95hiPVk/CMg7MEWUbzcJ)
Need help sorting, filtering, and summing my list. May be in over my head on this one.
https://docs.google.com/
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jul 20, 2013
user post by Aaron Issacs (http://productforums.google.com/forum/?zx=cxfn6lem6psg#!searchin/docs/InOverMyHead/docs/2xTx95hiPVk/CMg7MEWUbzcJ)
Need help sorting, filtering, and summing my list. May be in over my head on this one.
After one of you wizards put up a single line capable of performing this bit of shifting and sorting, I'll look at it and think to myself - I want his brain, lol.
Looking to filter (Sheet1/UniqueID) 123's data into (Sheet2) "123'sTotals". As shown in the Shared Spreadsheet below, I want to use the Legend Column Header 'EMOTIONS' on Sheet1 as Row Headers in Sheet2. Then, sum the total number of 10's (Happy's), 9's (Funny's), 8's...1's, by EMOTION into blocks of time (every 5 minutes) with reference to the Timestamp on Sheet1.
Any help is appreciated! Thank you.
Aaron
----------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment