yogi_Insert An Image In A Sheet Of Google Spreadsheet To Line Up With The Top Most Row

                                          Google Spreadsheet   Post  #886
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 23, 2012
user Miturbe72 said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/4TwkKkh3654)How to add image and align to very top of sheet.

Hello,

I have added an image to a spreadsheet but am unable to flush it to the very top, as this capture shows

These seems to be a top margin, buffer, header, menu.. whatever it is, just above the image, which becomes part of the image realestate that I cannot ger rid off!

Extremely annoying!

Thanks 

---

Here is a quick video of how I added the image:

http://screencast.com/t/KHpzEmIuc

I shared the sheet here:

https://docs.google.com/spreadsheet/ccc?key=0AtLpsx0xwQ5-dDY4NGZwQWQ3TzJjLUFwc244QUlpTmc

"Public on the web - Anyone on the Internet can find and edit"

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

 following is a solution to the problem ... wherein I have inserted the image using the IMAGE function.

yogi_Use Countif To Correctly Count Number Of Specified Entities In Cells With Data Validayogi_Use COUNTIF To Correctly Count Number Of Specified Entities In Cells With Data Validation (With Inadvertent Leading And Trailing Spaces)

                                          Google Spreadsheet   Post  #885
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 23, 2012
user Veryblacklabel said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/Ub36TORgoxg)
Problems with formula Countif when used in a column with 'validation' in cells.

Hey,

I have problems using the formula Countif when I want to get results from cells with al list ('validation').

This seems to work in Microsoft Excel but not in Drive Sheet.

I would be thankful if someone could help me with this issue.

Greetings,

Johny

Here is the link  https://docs.google.com/spreadsheet/ccc?key=0AijLMuDTan6ldEJvcnpOaF93V0xMbUhvVk14b09tZmc

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

 following is a solution to the problem ... although ideally there should be no leading or trailing spaces in the DataValidation List, I have noticed people often enter the list with comma as the delimiter but also an inadvertent space. With the use of the TRIM function one gets the correct count even with the inadvertent leading and trailing spaces present
 

yogi_Pull Data From Spreadsheet Standings For Position Sales And ReOrder Pulled Data By Rank In Ascending Order

                                          Google Spreadsheet   Post  #884
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 23, 2012
user batt1eship1 said: (http://productforums.google.com/forum/#!mydiscussions/docs/OxS_6fF5Flk)
Hello,

I have created two spreadsheets, one that has a ranking of names, so:

Sheet 1 (Rankings Page)

A B C

1 John AZ

2 Bill CO

3 Joe NY

Sheet 2 (Joe's page)

A B

Joe Rank 

So, i want "Rank" on Sheet 2 to pull Joe's rank of '3' from sheet one and import it into 'B' of sheet 2... so that if sheet 1 was resorted, and let's say i moved Joe to No. 2, Sheet 2 would reflect the new rank of 2 and import "2" into column "B" of sheet 2.

Hope that makes sense.

Thanks!

---

 Yogia:

Ok, I made the question a little more simple, direct and I have provided the "spreadsheet" links below, which are shared. I have also described what i want on each spreadsheet, but go to the first link and then the second. 

Thanks!

Go to this spreadsheet FIRST: https://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dGI0anVQZWR6RWNuZ05YYjBIUmFPTkE#gid=0

Then go to this one after: https://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dHRqUzBFUlJMNjE4YWo0bnVUamtVdEE#gid=0

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

 following is a solution to the problem

yogi_Extract Latest Date From Sheet1 Column B Where Sheet1 Column A Houses 1

                                          Google Spreadsheet   Post  #883
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 22, 2012
user overtorp1 said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/qkD8LnLQJKY)

Search latest date from all date with #1

How to search the latest date of all ex. #1 date from Sheet2

https://docs.google.com/spreadsheet/ccc?key=0Aqm4s16mMPw0dGhWZFFGLTMwYU53SE45UldhZ0JOd2c#gid=0 

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

following is a solution to the problem 

yogi_Compute The Total Distance Traveled In Last 7 Days Where Column C Lists Dates In Cells C5 C11 C17... And Distances In Cells C6 C12 C18 ...

                                          Google Spreadsheet   Post  #882
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 22, 2012
user ed-oxford said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cj7Hknqe_0U)
Fixing a problem with references to cells of a column
Windows 7

Dear all,

I need some help with the following formula, which does not work:

VERSION 1=ARRAYFORMULA(FILTER(C:C,IF(MOD(ROW(C:C),6)=0,IF(TO_PURE_NUMBER(TODAY())-TO_PURE_NUMBER(OFFSET(C:C,-1,0))<=7,TRUE()),FALSE())))

The very similar version works:

VERSION 2=ARRAYFORMULA(FILTER(C:C,IF(MOD(ROW(C:C),6)=0,IF(TO_PURE_NUMBER(TODAY())-TO_PURE_NUMBER(OFFSET(C:C,+5,0))<=7,TRUE()),FALSE())))

but does not get the right result.

These formulas are meant to go through column C, which has the following information: C5 is a date and C6 the distance covered that day, C11 is the next date and C12 the distance for that day, and so on for many rows. The pattern is a cycle repeated every 6 cells: starting from C5 there is a date, and then right below at C6 a distance, and again C11 and C12, C17 and C18. The formula above filters column C so that it takes all distances (contained in C6, C12, C18, etc.) and then (incorrectly) also picks up the dates of those distances (C5, C11, C17, etc.) and compares them to TODAY(), and if the distance was covered in the last seven days, it prints it.

I don't know why Version 1 does not work. It gives an error which I suspect is because doing OFFSET(C:C,-1,0) has the consequence that it picks up row 0, which is a reference error. I have tried to make version of it that wrap OFFSET inside of an IFERROR, but none of that seems to fix the problem. Maybe there's a way to fix this, but I don't know it.

Version 2 does not work because it associates the wrong date with a distance. For instance, the date in C11 is pegged with distance C6, when in fact the date C5 should be pegged with distance C6.

I imagine two solutions for this:

1) Fix Version 1 so that it can avoid whatever error creeps in, or

2) Maybe it's possible to start column C not from row 1, which is what ARRAYFORMULA does, but at another higher row. In this case, even starting at row 2 (so element C2) should be enough.

Please help.

Best

Ed

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

following is a solution to the problem, and in Sheet2 I have provided a solution to a bit more generalized problem

 

yogi_WorkAround For Using SUMIF With WildCard * In Google Spreadsheet

                                          Google Spreadsheet   Post  #881
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 21, 2012
user BasL said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BFUtcad0PEo)
Using jokers and cells in sumif
Hi Guys,

I am working on a spreadsheet and got a question regarding the sumif function. I want to combine a condition from a cel and a joker. In the spreadsheet (see link below) i want to get 70 in the "error" cel.

I tried various formulas like:
=sumif($A$13:$A$15;"*&A12*";$B$13:$B$15)
=sumif($A$13:$A$15;"=""*"&A12"

*"";$B$13:$B$15)

If it is possible to explain why and when the " " and & are used that would be an added bonus for me. I googled for about an hour now and this seems to be a big mystery (at least for me).

Thanks in advance

Regards

Bas

Link:
https://docs.google.com/spreadsheet/ccc?key=0AlinFMGf4J_AdE5JTkl0aXlSNjk0SE9IeFUxby1tTmc

 ----------------------------------------------------------------------------------
 following is a solution to the problem

yogi_Import Data From Spreadsheet1 For Subject Field To Be Science And Data Ordered in Descending Order By TimeStamp

                                          Google Spreadsheet   Post  #880
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 20, 2012
user batt1eship said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/t48wmBLFVRg)
How to pull data from a one Spreadsheet (that collects through a form) and display only some results (and sort by date)
Ok, first off, this forum community rules, and as I get versed in this stuff, I ensure you that it is my intention to give back and answer as many questions as I can. 

My question: 

So, I have Spreadsheet 1, collecting data through a form:

A | B | C | D

Submission Date | Writer Name | Content   | Subject

11/9/12               | Bob             | blah blah | Fiction

11/10/12             | Jim             | blah blah | Science

11/11/12             | Kate           | blah blah  | Math

11/12/12             | Dan            | blah blah  | Science

* and again, this is all submitted by a form, so the newest content is imported automatically at the bottom

Then, I have Spreadsheet 2, which I want to import the data from Spreadsheet 1, but:

• I only want Science entries to populate, and we will call Spreadsheet 2 "Science" spreadsheet
• I then want the data, so both Jim's and Dan's entries to sort by newest to oldest on this new "Science" spreadsheet
• &, of course any new "Spreadsheet" entries with a "subject" of "science" in column D, I would like those to of course import automatically in the future to "Science Spreadsheet" and remain in "newest" to "oldest" format.

Actual Spreadsheets:

Spreadsheet 1: https://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dE44V1V1QXNuVGFwUl9SWG9ZbXhuTlE#gid=0

Science Spreadsheet (spreadsheet 2): https://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dEg5ZVE0WGRhNUhfOWJjSkRfdFNNaFE#gid=0

Thanks again!!!

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

 following is a solution to the problem