yogi_Match A Specified Phrase In Column A of SpreadsheetB And Pull Data From Matching Row In Column F

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user DjDurland said:

Ok so, I have a friend that has their own Spreadsheet. What I would like to do is, have my spreadsheet search theirs in the A column for a specific word. Once it finds that word, I want it to return the value in the F column, same row. Example:
Search A column for "Crash". Once it finds "Crash", return F column of the same row, which is "20".
Any idea how I do this?
------------------------------------
following is a solution to the problem

I pulled into SpreadsheetA (poster's spreadsheet) the required matching data from SpreadsheetB (poster's friend's spreadsheet.

yogi_Count Number Of Occurences Of Dates As Labels In Style 01/01/2012 Across A Row

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

user sticknrudder said:
For example:
A1 A2 A3 ..... A7
Person    Location A.            Location B        Totals
John   1/1/12,1/2/12,1/5/12    1/7/12,1/12/12         5
Jane
Alan
Alana
...
...
...
All I want is a sum of the number of occurences of "*/*/*" in each cell, summed in that last row. Sorry, this is really basic, but I cannot figure this out and it's killing me.
---------------------------------------
following is a solution to the problem

yogi_Tryouts_20120203h1-fr-Publising List View

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

yogi_Group The Entities In A Column By Specified Categories And Present The Breakdown Graphically

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

use annetteit said:
hello,
i've done a questionnaire and i have a column with the age of all the people that have answered this questionnaire.
i would like to group the ages of the people in 3 categories ranging from 20 - 35, 36-50 , 50+
how can google docs sort the column with the ages of people into these 3 categories so i know how many people there are in each categories and can see it graphically?
---------------------------------
following is a solution to the problem

yogi_Create List Of Employee And The Related Amount For Each Employee's Individual Sheet

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

user beejizzle said:
I have this Summary sheet with names in column A of my workers, each worker has a own Sheet with his name. And it list a amount from a cell in that sheet
If I have the sheets "Summary", "John", "Josh", "Mike" then the column a in summary would be (and column B would have the amount):
John John!B1
Josh Josh!B1
Mike Mike!B1
Now if I add one new sheet is it possible to have it autoadded below "Mike" ? I know I could enter a pre-added value but then I couldnt name the sheets to a specefic name cause I wouldnt know in advance. Can I use sheets GID somehow or do I have to like pre-add like 20 sheets for coming workers and pre-name the sheets to like Worker1 , Worker2 etc?
Hope you understand
----------------------------------
following is a solution to the problem

yogi_Sum Up Values by Key That Match The Items In A List

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user bvboe said:
I have three columns, a key and value pair, and a list of keys. I want sum the values for all keys that appear in my list of keys. Eg:
KEY VALUE LIST
A     1    A
A     2    B
B     3    B
B     4    B
C     5    A
C     6    Z
D     7
D     8
What I am trying to get is
RESULT
3
7
I have searched and tested for months with no success. Any help would be enormously appreciated.
2011-12-29
Sorry, I just realized I wrote the subject wrong, it should b:
select sum(b) where a IS IN ARRAY(c2:c)
--------------------------------
following is a solution to the problem

yogi_Get Map And Compute Distance Between Start Address And Destination Address

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

some formulas we had developed earlier to compute distance between two addresses as reported in some recent posts in Google Docs Help forum stopped working a few weeks ago.
So here I present a solution to the problem -- and the new formulation is a lot simpler than in the older formulas that we had presented in some earlier threads in Google Docs Help forum:
------------------------------------
so here we go

View Larger Map