It will likely have been solved by now, but I ran accross this and figured to give my input

    =COUNTIF(a2:a51;&quot;*iPad*&quot;)

The important thing is that separating parameters in google docs is using a `;` and not a `,`

In case someone is still looking for the answer, this worked for me:

```
=COUNTIF(A2:A51, &quot;*&quot; &amp; B1 &amp; &quot;*&quot;)
```
```B1``` containing the ```iPad``` string.

You should use 

`=COUNTIF(A2:A51, &quot;*iPad*&quot;)/COUNTA(A2:A51)`

Additionally, if you wanted to count more than one element, like iPads OR Kindles, you would use 

`=SUM(COUNTIF(A2:A51, {&quot;*iPad*&quot;, &quot;*kindle*&quot;}))/COUNTA(A2:A51)`

in the numerator.

Try using wildcards directly in the COUNTIF function : 

    =(COUNTIF(A2:A51,&quot;=*iPad*&quot;)/COUNTA(A2:A51))*1

Wildcards worked for me when the string I was searching for could be entered manually. However, I wanted to store this string in another cell and refer to it. I couldn&#39;t figure out how to do this with wildcards so I ended up doing the following:

A1 is the cell containing my search string.
B and C are the columns within which I want to count the number of instances of A1, including within strings:

    =COUNTIF(ARRAYFORMULA(ISNUMBER(SEARCH(A1, B:C))), TRUE)

I had similar problem however the various count solutions still wouldn&#39;t work even with wildcards of `&quot;*&quot;&amp;` etc..... My problem was caused by &amp;nbsb (hidden spaces) which is hidden in the background when copying eg data from a webpage. This prevents the find from working properly. Use:

     =TRIM(SUBSTITUTE(A2, CHAR(160), &quot; &quot;)) 
or

     =TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32))) 

or similar to get rid of them.

Try just `=COUNTIF(A2:A51,&quot;iPad&quot;)` 
&lt;!-- Please remove this comment which overcomes character limit. --&gt;

Having the darnedest time trying to figure out why minification is not working.

I have injected via an array object my providers prior the function per numerous suggestions across the web and yet still &quot;Unknown provider: aProvider &lt;- a&quot;

Regular:

    var app = angular.module(&#39;bpwApp&#39;, [&#39;ui.bootstrap&#39;, &#39;ui&#39;, &#39;myTabs&#39;])
        .config([&#39;$routeProvider&#39;, &#39;$locationProvider&#39;, function($routeProvider, $locationProvider){
        $routeProvider.
            when(&#39;/&#39;, {templateUrl: &#39;partials/home.jade&#39;, controller: HomeCtrl});
        
        $locationProvider.html5Mode(true);
        }])

Minified: 

    var app = angular.module(&#39;bpwApp&#39;, [&#39;ui.bootstrap&#39;, &#39;ui&#39;, &#39;myTabs&#39;])
        .config([&#39;$routeProvider&#39;, &#39;$locationProvider&#39;, function(a, b){
        a.
            when(&#39;/&#39;, {templateUrl: &#39;partials/home.jade&#39;, controller: HomeCtrl});
        
        b.html5Mode(true);
        }])

Any suggestion would be much obliged!


Angular.module minification bug

*The question is about Magit major mode for Emacs function and less so about how to do this via command line interface.*

I only have a local Git repository. How would I restore a selected file to its previous version? I believe that the Git command for this must be something like `git checkout HEAD^ path/to/file` but I may be wrong here too, just guessing really.

What I&#39;m looking for is essentially the same thing as &lt;kbd&gt;C-x v u&lt;/kbd&gt; in `vc-dir` buffer.

Essentially, what I was hoping to do was:

* delete the modified file.

* pull from local repo.

But **Magit** doesn&#39;t seem to be able to do that, it seems to prefer to just delete the file, instead of restoring it.

Magit revert single file

I have a column like this: 

What devices will you be using? 

    iPad
    Kindle &amp; iPad
    No Tablet
    iPad
    iPad &amp; Windows

How do I count the amount of people that said iPad?

This formula does work for exact matches but not if it contains an additional value: 

    =(COUNTIF(A2:A51,&quot;=iPad&quot;)/COUNTA(A2:A51))*1


Any Suggestions?



Google Spreadsheet, Count IF contains a string

I have a column like this:
What devices will you be using?
<pre><code class="hljs language-rust">iPad
Kindle &#x26; iPad
No Tablet
iPad
iPad &#x26; Windows
</code></pre>
How do I count the amount of people that said iPad?
This formula does work for exact matches but not if it contains an additional value:
<pre><code class="hljs language-less">=(COUNTIF(A2:A51,"=iPad")/COUNTA(A2:A51))*1
</code></pre>
Any Suggestions?

I&#39;ve written a custom Google Apps Script that will receive an `id` and fetch information from a web service (a price).

I use this script in a spreadsheet, and it works just fine. My problem is that these prices change, and my spreadsheet doesn&#39;t get updated.

How can I force it to re-run the script and update the cells (without manually going over each cell)?

Refresh data retrieved by a custom function in Google Sheet

I want to calculate the product of two different columns (e.g., A &amp; B) for each row on my spreadsheet. For a single row, this would work by using `=PRODUCT(A1:B1)`, but I can&#39;t figure out how to get the function to use the current row instead of a manually entered row. I know you can get a reference to the current row using `ROW()`, but I get an error when I try something like `PRODUCT(AROW():BROW())`.

Google Spreadsheet Formula to Use Current Row in Function

I have a sheet with data in cols `A` through `H`.

I need to determine the last row in column `A` that contains data (it&#39;s all contiguous - no gaps in the data/rows).

There is also data in the other columns that have *more* rows of data than column `A`, so I need to isolate only column `A`. (And/or just a range within col `A`). 

I can do this on the spreadsheet level using 

    =COUNTA(A2:A100)

However in all of my researching for a Google Apps Script solution, all I seem to find are requirements to perform multiple functions encompassing dozens of lines of code - including plenty of `i++` stuff... Which I could do less complexly via offsetting directly from `A1`.

Is there possibly a column-specific way of modifying this method?

    var aLast = ss.getDataRange().getNumRows();

If a convoluted process is what is required, then so be it. But I find it difficult to imagine (and even more difficult to find!) a simpler solution.

Does anyone care to enlighten me (or pop my bubble)?

Determining the last row in a single column

I uploaded a file to Google spreadsheets (to make a publically accessible example IPython Notebook, with data) I was using the file in it&#39;s native form could be read into a Pandas Dataframe. So now I use the following code to read the spreadsheet, works fine but just comes in as string,, and I&#39;m not having any luck trying to get it back into a dataframe (you can get the data)

    import requests
    r = requests.get(&#39;https://docs.google.com/spreadsheet/ccc?key=0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc&amp;output=csv&#39;)
    data = r.content

The data ends up looking like: (1st row headers)

    &#39;,City,region,Res_Comm,mkt_type,Quradate,National_exp,Alabama_exp,Sales_exp,Inventory_exp,Price_exp,Credit_exp\n0,Dothan,South_Central-Montgomery-Auburn-Wiregrass-Dothan,Residential,Rural,1/15/2010,2,2,3,2,3,3\n10,Foley,South_Mobile-Baldwin,Residential,Suburban_Urban,1/15/2010,4,4,4,4,4,3\n12,Birmingham,North_Central-Birmingham-Tuscaloosa-Anniston,Commercial,Suburban_Urban,1/15/2010,2,2,3,2,2,3\n

The native pandas code that brings in the disk resident file looks like:

    df = pd.io.parsers.read_csv(&#39;/home/tom/Dropbox/Projects/annonallanswerswithmaster1012013.csv&#39;,index_col=0,parse_dates=[&#39;Quradate&#39;])

A &quot;clean&quot; solution would be helpful to many to provide an easy way to share datasets for Pandas use! I tried a bunch of alternative with no success and I&#39;m pretty sure I&#39;m missing something obvious again.

Just a Update note The new Google spreadsheet has a different URL pattern Just use this in place of the URL in the above example and or the below answer and you should be fine here is an example: 

    https://docs.google.com/spreadsheets/d/177_dFZ0i-duGxLiyg6tnwNDKruAYE-_Dd8vAQziipJQ/export?format=csv&amp;id

see solution below from @Max Ghenis which just used pd.read_csv, no need for StringIO or requests...

Getting Google Spreadsheet CSV into A Pandas Dataframe

I&#39;m looking for a way to &#39;pre fill&#39; a google form with specific data from a google spreadsheet. The form will have the same &#39;standard&#39; questions for everyone, but the data in the first two question will be &#39;prefilled&#39; with unique data from an existing google spreadsheet. The data will be unique based on their email address in the existing spreadsheet.

**SOURCE SPREADSHEET EXAMPLE**

&lt;!-- language: lang-none --&gt;

    Col 1       Col 2        Col 3 
    email       name         birthday  
    @mike       Mike Jones   May 9th 1975  
    @jim        Jim Smith    April 19th 1985

---

**FORM EXAMPLE ONE**

Question 1 - prefilled with data **(Mike Jones)** from a google spreadsheet.  

Question 2 - prefilled with data **(May 9th 1975)** from a google spreadsheet.  

Question 3 - blank (awaiting user response)

Question 4 - blank (awaiting user response)


---
**FORM EXAMPLE TWO**

Question 1 - prefilled with data **(Jim Smith)** from a google spreadsheet.  

Question 2 - prefilled with data **(April 19th 1985)** from a google spreadsheet.  

Question 3 - blank (awaiting user response)

Question 4 - blank (awaiting user response)

---
Does anyone know if this can be done? If yes, any help or direction will be GREATLY appreciated.

Thank you in advance!  
Todd


Is it possible to &#39;prefill&#39; a google form using data from a google spreadsheet?

I am reading about generic methods from [OracleDocGenericMethod][1]. I am pretty confused about the comparison when it says when to use wild-card and when to use generic methods.
Quoting from the document.

&gt;     interface Collection&lt;E&gt; {
&gt;         public boolean containsAll(Collection&lt;?&gt; c);
&gt;         public boolean addAll(Collection&lt;? extends E&gt; c);
&gt;     }
&gt; 
&gt; We could have used generic methods here instead:
&gt; 
&gt;     interface Collection&lt;E&gt; {
&gt;         public &lt;T&gt; boolean containsAll(Collection&lt;T&gt; c);
&gt;         public &lt;T extends E&gt; boolean addAll(Collection&lt;T&gt; c);
&gt;         // Hey, type variables can have bounds too!
&gt;     }
&gt; […]
&gt; This tells us that the type argument is being used for polymorphism;
&gt; its only effect is to allow a variety of actual argument types to be
&gt; used at different invocation sites. If that is the case, one should
&gt; use wildcards. Wildcards are designed to support flexible subtyping,
&gt; which is what we&#39;re trying to express here.

Don&#39;t we think wild card like `(Collection&lt;? extends E&gt; c);` is also supporting kind of
polymorphism? Then why generic method usage is considered not good in this?

  [1]: http://docs.oracle.com/javase/tutorial/extra/generics/methods.html

Continuing ahead, it states,

&gt; Generic methods allow type parameters to be used to express
&gt; dependencies among the types of one or more arguments to a method
&gt; and/or its return type. If there isn&#39;t such a dependency, a generic
&gt; method should not be used.

What does this mean?

They have presented the example

&gt;     class Collections {
&gt;         public static &lt;T&gt; void copy(List&lt;T&gt; dest, List&lt;? extends T&gt; src) {
&gt;         ...
&gt;     }
&gt; 
&gt; […]
&gt;
&gt; We could have written the signature for this method another way,
&gt; without using wildcards at all:
&gt; 
&gt;     class Collections {
&gt;         public static &lt;T, S extends T&gt; void copy(List&lt;T&gt; dest, List&lt;S&gt; src) {
&gt;         ...
&gt;     }

The document discourages the second declaration and promotes usage of first syntax? What&#39;s the difference between the first and second declaration? Both seems to be doing the same thing?

Can someone put light on this area.



When to use generic methods and when to use wild-card?

I have a device that is already mapped to `domain.tld`. I now want to create a wildcard for all subdomains `*.domain.tld` so that they are mapped to the ip of `domain.tld`, too.
How do I do this with `dnsmasq`?


Wildcard subdomains with dnsmasq

I have mongodb with a `$text-Index` and elements like this:

    {
       foo: &quot;my super cool item&quot;
    }
    {
       foo: &quot;your not so cool item&quot;
    }

If i do search with 

    mycoll.find({ $text: { $search: &quot;super&quot;} })

i get the first item (correct).

But i also want to search with &quot;uper&quot; to get the fist item - but if i try:

    mycoll.find({ $text: { $search: &quot;uper&quot;} })

I dont get any results.

My Question:
If there is a way to use $text so its finds results with a part of the searching string? (e.g. like `&#39;%uper%&#39;` in `mysql`)

**Attention: I dont ask for a regex only search - i ask for a regex-search within a $text-search!**


mongoDB prefix wildcard: fulltext-search ($text) find part with search-string

I bought a wildcard certificate for *.example.com. Now, I have to secure *.subdomain.example.com. Is it possible to create a sub-certificate for my wildcard-certificate? 

If it is, how I can do this?

SSL Multilevel Subdomain Wildcard

I&#39;ve tried the following command but I am having trouble interpreting the results:

```bash
ls **
```

I&#39;m not sure exactly what it is outputting and why.

Content Type	Original Author	Original Content on Stackoverflow
Question	Cody	View Question on Stackoverflow
Solution 1 - Google Sheets	Perry	View Answer on Stackoverflow
Solution 2 - Google Sheets	user2983604	View Answer on Stackoverflow
Solution 3 - Google Sheets	YPCrumble	View Answer on Stackoverflow
Solution 4 - Google Sheets	Simon	View Answer on Stackoverflow
Solution 5 - Google Sheets	Rupert Madden-Abbott	View Answer on Stackoverflow
Solution 6 - Google Sheets	CoolHands	View Answer on Stackoverflow
Solution 7 - Google Sheets	Kevin	View Answer on Stackoverflow

Google Spreadsheet, Count IF contains a string

Google Sheets Problem Overview

Google Sheets Solutions

Solution 1 - Google Sheets

Solution 2 - Google Sheets

Solution 3 - Google Sheets

Solution 4 - Google Sheets

Solution 5 - Google Sheets

Solution 6 - Google Sheets

Solution 7 - Google Sheets

Magit revert single file

Angular.module minification bug

Attributions