Saturday, February 2, 2013

yogi_Build CompositeReport From Form Responses Sheet Using Specified Criteria


                                          Google Spreadsheet   Post  #1006
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 02, 2013
post by user: Kristof P said:(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/8rVCJ1Znp2k)
Build manual report for Google Forms - how to perform outer join
Hi all,

I am building a report to process the results of an evaluation form.

In the output of my report, I want to mark self-evaluations with an *, as illustrated in the Report tab of the following spreadsheet:

Is there any way to create the desired output solely using spreadsheet formulas?

Thanks,

Kristof
----------------------------------------------------------------------------------------------
following is a solution to the problem