Monday, October 29, 2012

yogi_Create User Specified Reports By Month And Year And For This Week Last Week And Week Before Last Week


                                           Google Spreadsheet   Post  #836
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 29, 2012
user mojo_247 said: (http://productforums.google.com/forum/?zx=g9a265uola4#!category-topic/docs/spreadsheets/Py3sTHEixXY)
need help with creating a report from table
Hi 

I'm using a large spreadsheet, off which I need to generate various report.

Following is a very small sample of the data and the reports I need to generate.


Could I please get some assistance with this.

TIA
------------------------------------------------------------------------------------

following is a solution to the problem

1 comment:

  1. Hi Mojo:

    Oh alright so you need to report the number of 'yes' for each person within the timeframe ... no problem, you can do that.

    If you need further help with this please post back with your expected result and the needed logic/explanation as to why that is the correct result and then let us take it from there.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete