yogi_Count Cells Filled In A Column That Are Not In Another Specified Column

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

a user said:
Count cells filled in column A that are not in B, and vice-versa
I happen to have columns A and B, each filled with “X”s:

A B
X
X
X X
X
X
X
X X

How do I count the number of cells filled in A that are not in B, and vice-versa? There is this undocumented Google Docs function, but I couldn’t understand how it works: COUNTUNIQUE().
For A it should be 3, and for B just 2. ----------------------------------------

yogi_Sum Rows of Columns With Minimum Value In A Specified Column

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

a user said:
How do I sum certain cells of a row that has the min value in a column?
I first need to find the cell containing the min value in a column and then I need to take the cell's row and sum certain cells in that row. Basically, SUM(C#,D#,F#,G#) where # is the row number that has the min value in column H - any ideas?
-------------------------------------

yogi_Search For @ Character And Extract Company Name And Email Address In Another Sheet

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

In this case I have based presence of email simply by searching for existence of @ character in the Info field
the two part solution consists of
1) filtering for all records that contain @ character in the Info field ... in Sheet2
2) then extracing in an adjacent column only the email address from the filtered Info field
------------------------------------

yogi_Extract In A Separate Sheet Records With Valid Email Addresses

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

a user said:
Delete rows that don't contain email addresses
I have 4,000 rows with 2 columns. Column A contains the name. Column B contains cells that contain an email address amongst other data. I want to delete rows that don't contain email addresses. Also I want to delete everything but the email address in that cell of Column B. Can you help?
-------------------------------

yogi_Extract Data Into Another Sheet Based On Row Number In The Sheet

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

a user asked:
display a specific row on a second sheet
I am trying to get the cells on Sheet2 to display information from Sheet1 based on the row I select. For example if I have a basic spreadsheet with columns of Firstname and Lastname, I would like to go to Sheet2 and select row 2 (from Sheet1) and have it display John Smith. The basic formula I had hoped would work was =Sheet1!B(A1) where A1 was 2 but that returned a parse error. Any help would be appreciated.
-------------------------------------
original data is in Sheet1; in Sheet2 I have extracted data in an entire row of Sheet1 based on row of Sheet2

yogi_Sort Data In Another Sheet By Specified Column In Specified Order

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

a user asked:

How do I sort sheet 1 column BI'm new to Google docs and have used excel for most everything. This simple sort on excel by pop up box (sort by COLUMN B, sort on VALUES, order LARGEST TO SMALLEST) I can not figure out on Google docs. Column A is names and must stay with the associated data in column B. Column B is scores being populated by sheet 2. The scores change weekly by the data entered on sheet 2. A manual sort is fine, but if it could be an auto sort that would be even better.-----------------------------------------------------

Data is in Sheet1 ... and using the SORT function, I have sorted it in Sheet2

yogi_Extract Entries That Are Unique For A Specified Column

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

a user asked:
How do I find/delete duplicate contact entries in a spreadsheet?
I have 1450 contact entries in a spreadsheet. They each have fax, telephone, name, and company.
I need to identify and delete any entries with a duplicate fax number. Also, I need to retain the integrity of the spreadsheet upon identifying and deleting, such that corresponding records stay with each other.
Fax Tel Name Company
919-807-3450 919-807-1234 Jonathan Peters Swift, Inc.
919-807-3450 919-807-3456 Jenny Carr Swift, Inc.
919-663-0876 919-779-9734 Alex Grafton Thorsys, Inc
Ex - Jonathan and jenny would be identified as being duplicates and I would delete 1 of them. *the entry selected to be deleted would deleted completely, such that Alex would then be the 2nd entry, with all of his records.
Any help is a great help!
------------------------------------------------------------