yogi_Compute Difference In Various Day Columns From BaseValues In Column A

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Column A has BaseValues, Columns B, C, and D have values for Monday, Tuesday, and Wednesday. In column E I compute the difference for Monday Column values from BaseValues in Column A. Then the formula can be applied for computing for Tuesday, and Wednesday Columns
-----------------------------------------------------------

yogi_Check How Do Values Of Entries in Column A Compare With Those In Column B

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Compare values of entries in column A with those in column B and post whether all of entries in column A are greater than those in column B
---------------------------------------------------------------

yogi_Create PivotTable From Form Data Get Counts By Specified Attributes Publish PivotTable

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Data is submitted via a Form for Car Class, Drivers Name and Racing Yes or No.
Need to create a single PivotTable by Car Class and Drivers Name showing who is racing, who is not racing and their respective counts
----------------------------------------------------------
In the proposed solution here, I created two computed fields (shown in light brown background) to x mark Race or NoRace ... this works out nicely showing the needed information.

family and friends: Googling With Googlers At Google's Global Top Contributors Summit 13-14 Sep 2011

family and friends: Googling With Googlers At Google's Global Top Contributors Summit 13-14 Sep 2011: Googling With Googlers At Google's Global Top Contributors Summit 13-14 Sep 2011

yogi_Sum A Column From Row 2 Down And Use This Sum To Divide The Value In Specified Row Of Another Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

lunixer said:
How do I sum an entire column up to the row where I am and keep this formula consistent in later rows?
Okay, here's what I want to do:
In cell L3 I want to put the formula: =K3/SUM(C2:C3)
In cell L4 I want to put the formula: =K4/SUM(C2:C4)
Then I want to be able to paste this same formula throughout the entire L column, so that the summation always goes from C2:C# where # is equal to L#. However, when I paste this formula, eg from L3 to L5, it changes it to be L5=K5/SUM(C4:C5). And when I highlight the first two cells with this formula and drag, it maintains a three cell difference. So L6=K6/SUM(C4:C6). Do you have any idea how I would make this automatic?
---------------------------------------------------------

yogi_Lookup Address Changes For Same Names In Sheets 1 And 2 And Paste Original And Changed Addresses In Sheet3

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

veritasins said:
I have a contact list in Sheet 1 with the columns A-D and the titles Name, Address, Phone, Email. I have a similar contact list in Sheet 2. I need to know if there are any differences in the two sheets (need to find duplicates from Sheet 1 Column B and Sheet 2 Column B)....Specifically the Address Column. The perfect situation would be to be able to to show the entire contact that is NOT duplicate in Sheet 3 with Name, Address, Phone, and Email.
The way this works is I am downloading a contact list each month and I need to find out if there are any differences between the two lists each month to see if anyone has changed their address.
If I needed to, I could just have Sheet 2 Column E show the word Duplicate if that is an easier formula.
I was hoping that this formula posted by A.P.L. would work - =ArrayFormula( IF( LEN( A:A ) * ( COUNTIF( A:A ; A:A ) > 1 ) ; "Duplicate" ; IFERROR( 1/0 ) ) ) and I could just add Sheet2! to one of the formulas, but I can not get it to work.
I also tried a formula by yogia but I could not get it across two sheets either.
Browser & Operating System (Chrome):
Using Free Google Apps
-------------------------------------------------------------

yogi_Select Names Of Top Scorers

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

saxxoo said:
selecting names with highest score
I got this formula I'm using for selecting a name (B row) with the highest number (H row)
I looked through the formulas without finding anything that seemed to fit my need, so is there any way to get it to give out like the best
5 names instead of just the one with the highest number.?
=ARRAYFORMULA(SUBSTITUTE(CONCATENATE( FILTER(B2:B91; H2:H91=MAX (H2:H91))&", ")&",";", ,";""))
-----------------------------------------------------------------