Google Spreadsheet is part of the Google Docs suite of office tools. See our sister Stack Exchange, Web Apps for more focussed questions and answers on Google Spreadsheet and other Google Docs applications.
0
votes
0answers
21 views
In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function? [migrated]
I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
0
votes
2answers
98 views
How do I calculate the sum of 2 columns, using the max from each row?
I have data in two columns. I would like the sum of the two columns, using the maximum value for each row.
For instance
C1 C2
1 2
4 3
11
10
5 7
The result would be ...
1
vote
0answers
48 views
Searching a CSV or Excel file for terms from one column of another Excel file [closed]
I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open ...
1
vote
2answers
72 views
Advanced spreadsheet auto-formatting
Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet
2
votes
1answer
139 views
What MS Excel functions are not supported in Google Docs Spreadshets? [closed]
The title pretty much says it all. Is there a place where one can see the comparison between Google Docs Spreadsheets and MS Excel, or to be precise, to find out what MS Excel functions are not ...
1
vote
0answers
78 views
Spreadsheet formula to count consecutive values in a column
I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this:
Y
Y
Y
N
Y
N
Y
Y
the desired result would be 2
Y
Y
...
2
votes
2answers
2k views
How to create a formula for every row in a column in Google SpreadSheet?
I use three columns. A, B and C.
In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2.
How can I do so I don't have to type in the new formula in ...
1
vote
1answer
61 views
How to visualize historical data
I have inherited a horrible spreadsheet with 4 years of data about when people participated in a given activity, by month. Each person would likely participate once every 18 months or so, but ...
0
votes
2answers
183 views
How do I simplify this if statement to just add 1 every time (and possibly go with no limit)?
=if(C24 ='Ability Base'!$A$2;sum('Ability Base'!$B$2);
if(C24 ='Ability Base'!$A$3;sum('Ability Base'!$B$3);
if(C24 ='Ability Base'!$A$4;sum('Ability Base'!$B$4);
if(C24 ='Ability ...
0
votes
2answers
294 views
Encrypting content on a google spreadsheet [closed]
I have a spreadsheet that contains passwords so I can access them from anywhere. I make sure I always access it using https. However, I'm concerned that someone may steal my gmail password and access ...
1
vote
1answer
506 views
excel / google spreadsheet: count substring occurrences within a cell
I've been scratching my head trying to figure out a way to count the number of occurrences of a substring within a cell.
For example:
| | A |
| 1 |John,John,Tom,David|
What ...
0
votes
0answers
42 views
extra quotation marks added when “downloading as text” google spreadsheets
I've done a google spreadsheet
I want to downdown the "code" sheet (see bottom left tab on spreadsheet) as "text", but when I do and open the resulting text file the code has extra quotation marks ...
0
votes
2answers
39 views
How do I delete a worksheet from a Google speadsheet? [closed]
I know it sounds simple but I have 2 problems.
On the first sheet I can delete the worksheet by clicking on the tab dropdown and clicking delete, but it reappears when I leave and come back.
On the ...
0
votes
0answers
563 views
How do I change the font formatting of cells in Google Spreadsheets? [closed]
I am trying to add checkboxes to a spreadsheet in Google Spreadsheets. I found an interesting solution to this problem here in Google's help. The second post on that thread states you can just format ...
0
votes
2answers
265 views
Spreadsheet formula: lowest 100 values in a range
Is there any way I could sum up the lowest 100 values within a range?
I know that min() would give you the lowest value but i need something to return the 100 lowest values.
I just used 100 ...
0
votes
1answer
724 views
Google Spreadsheet Indirect in a VLookup
I'm trying to convert an Excel spreadsheet into Google, but can't get this VLookup(Indirect)) combination to work.
My data sheets are named with a code, for example "fred01", and look like this:
...
4
votes
9answers
2k views
Can you convert an address to a zip code in a spreadsheet?
Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this?
I'm dealing ...
3
votes
1answer
1k views
How to freeze more than 5 column in google spreadsheet?
How to freeze more than 5 column in google spreadsheet?
1
vote
5answers
3k views
In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells?
I work with all three spreadsheet programs listed above, and I believe my question can be answered the same or similarly for all three.
On my sheet, I have a top row full of column headers. The ...
3
votes
4answers
1k views
How to open google spreadsheet's extra sheets in new window or tab?
How to open google spreadsheet tab in new window or tab?
0
votes
2answers
682 views
phpmyadmin import database table from google spreadsheet
I'm managing a small website, which allows people to register as members. Previously I used a google form to manage member registration, but now as the number of users becomes quite big I am ...
3
votes
2answers
6k views
Google Spreadsheet: Sum of all number values in a row? [closed]
I have a google spreadsheet with people's names and zeroes or ones, like this:
ODP 0 1 1 0 0 0 1 0
OMG 0 1 0 0 0 1 1 0
MJK 1 1 1 1 0 ...
1
vote
1answer
231 views
In Google Docs, how to create a form that can store the data entered into it in an excel sheet automatically?
The title pretty much says it all.
I need to create a poll wherein I need to ask the users some questions.
How can I do it using Google Docs? How will I access the data entered after that?
1
vote
1answer
2k views
Google Spreadsheets: Counting number of matches between two rows
In a spreadsheet in Google Spreadsheets, I have multiple-choice answers I would like to grade.
One row (user 0) contains the answer key, and the other rows contain user answers.
User Q1 Q2 Q3 ...
