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:

https://docs.google.com/spreadsheet/ccc?key=0ApdapvqhWYyrdFlyTmZGYWhwMmNCNi1aOE5PZ0tWWkE&usp=sharing

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

Thanks,

Kristof

----------------------------------------------------------------------------------------------

following is a solution to the problem