yogi_Unique Lookup Values Based on Multiple Criteria

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

Taz002 said:
Unique VLookup values based on multiple criteria
I am trying to somehow combine the UNIQUE() formula with a VLOOKUP() without any luck so far. I want to have it so if I change the name in a cell it will return a list that is automatically generated based on the name with each given unique data in column 2. Here is an example spreadsheet, any help appreciated.
---------------------------------------------------------
I have updated the following solution based on updating of the specification by Taz002

yogi_Sum Numbers By Specific Column Heading With Multiple Row Criteria

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

skiddooo said:

Sum numbers by specific col heading with multiple row criteria
I got a spreadsheet and want to sum it by specific crieteria and I'm not able to solve this problem by my self so I hope someone can help ^^
This is the Spreadsheet:
Course | Class Room | Peter | Paul
1 | Pluto | 8 | 4
1 | Pluto | 2 | 6
2 | Pluto | 8 | 4
2 | Mars  | 2 | 6
I want to know: How many hours did Peter spend in Class Room "Pluto" for Course "1"?
------------------------------------------------------------
I used primarily the FILTER function for this

yogi_Match Cell Data On Two Spredsheets And Merge The Results

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

rbjassoc said:
match cell data on 2x seperate spreed sheets and merge the result
I have 2x separate customer list saved in separate spreadsheets. Each customer has a unique email address. But the 2x spreadsheets have different data about that customer. I would like to use 1x spreadsheet as a master and merge the additional data from the second spreadsheet only to those unique email addresses that are on the first spreadsheet.
example sheet 1 example sheet 2 result sheet
email data email data email data data
j@et 10 j@et 20 j@et 10 20
g@wt 5  g@wt 45 g@wt 5 45
t@sd 7  r@ww 34
t@sd 14 t@sd 7 14
------------------------------------------------------------------------
following is an image of Sheet1 in Spreadsheet1

and here is an image of Shee2 in Spreasheet2

and here is the spreadsheet with the solution ...

yogi_Get Values From Different Columns Of A Table Based On Values In the First Column Of The Table

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

AAzad2010 said:

Based on entered ISBN #, fill in respective Title and Author field
I have a table with 3 columns: ISBN, Title, and Author. I want to enter an ISBN number and would like google spreadsheets to automaticly fill in the Title and Author columns. How do i do this? Thanks in advance.
---------------------------------------------------
In the following I have used the VLOOKUP function

yogi_Calculate Amount Spent In Specified Time Period By Item

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

trimonth said:
how do I compute amount spent in specified time period by item?
I am kind of working on a budgeting thing. If I have a column of dates and a corresponding column of dollar amounts, can I analyze the numbers based on when they occurred? For example, how much did I spend on groceries in the Summer? Over the last 3 years, what is the average of my utility bills in the Winter? How much did I spend eating out in the first 3 months of the year?
I am hoping that once I see how to split up a date, like in terms of seasons, I can extend it out to answer more complex questions.
Again, there might be an answer out there in the forums somewhere, but I may not be searching for them as well as I could.
-----------------------------------------------------------
We can consider the time period in quarters ... you may want to consider ...
Quarter1 ... as Winter
Quarter2 ... as Spring
Quarter3 ... as Summer
Quarter4 ... as Fall

yogi_Filter A Number Of Rows Based On Uniqueness Of A Single Column

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

santosh2 said:
Filter a number of rows based on uniqueness of a single column
I am using Google Forms to populate a Google Spreadsheet for use as a database. One item of data is used as an index for each entry/record. I would like to be able to filter the database to include only the most recent submission of data for all indices.
I.e. if the index is a record number, users may enter data for the following record numbers in this order: 1,2,3,4,3,1. I would like to extract from this database the most recent versions of 1,2,3, and 4. The second entries for records 3 and 1 would effectively overwrite the earlier entries.
----------------------------------------------
The responses are logged in a sheet named Form and the filtered records are shown in Sheet1

yogi_Calculate Average For Entries In A Column Based On Values In Another Column

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

nicomachus said:
How do I calculate the average of one column consistent with something from another column?
For example, let's say I have two columns. Possible entries in the first column are A, B, and C. The second column has numbers. I want to use the Average formula to find the average numerical value of all of the As. Then another for all of the Bs. Does that make sense?
--------------------------------------------------------------------