tag:blogger.com,1999:blog-8807805591547673516.post4410086558131111175..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Sum Up Attribute In Column C For Names In Column B For Specified DatesYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8807805591547673516.post-53903104015093429132011-11-17T22:18:33.625-08:002011-11-17T22:18:33.625-08:00Yogi,
Here is the link to my actual spreadsheet. ...Yogi,<br /><br />Here is the link to my actual spreadsheet. I can't get the ArrayFormula formula to work...<br /><br />https://docs.google.com/spreadsheet/ccc?key=0Agcb8bUVVOOodEhzeEI1N0pkbExFbnJ1cEY0SFZpV1EAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-91247086326980405012011-11-17T20:53:22.857-08:002011-11-17T20:53:22.857-08:00Yogi,
When I enter the transpose formula for cell...Yogi,<br /><br />When I enter the transpose formula for cell F1, <br /><br />=transpose(query(unique(B3:B),"select Col1 where Col1<>" ")),<br /><br />I get the error "Make sure your formula has matching quotes". I tried =transpose(query(unique(B3:B),"select Col1 where Col1"<>" ")) but then I get #VALUE!......<br /><br />What do I need to do?Anonymousnoreply@blogger.com