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
15 views
Sum of numerical values excluding formulas in a Google Spreadsheet [migrated]
I have a long column of numbers in Google Spreadsheet, and occasionally there exists a cell that sums some of the cells below it. For example:
=SUM(2:4)
5
10
30
=SUM(6:8)
40
10
10
...
1
vote
0answers
80 views
Google Docs speadsheet auto-fill: control what increments
Is there a way to control which variables in a formula get incremented when you use auto-fill in a Google Docs spreadsheet?
What I'm trying to do is convert a column of counts to a column of ...
0
votes
2answers
98 views
Spreadsheets: How do I perform functions on a set/array described by a row of (count, value) pairs?
I have excel 2000, google docs, and the latest open office calc available to me. I'm after a solution in any of those, ideally.
I have a multiset of data described by rows of (count, value) pairs. ...
1
vote
0answers
30 views
Alternative, more efficient scraping method for a noncoder, than Google doc's importxml and xpath?
I've searched throughout the net for a simple solution, but it seems everyone has their own unique method (coding language) of achieving this. I'm only just beginning to learn Linux, and my coding ...
2
votes
1answer
149 views
How to Label / Tag Items in a Spreadsheet
I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question.
Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the ...
2
votes
1answer
206 views
Spreadsheet, PHP Script, or Linux program for employee shift scheduling
I have been looking everywhere for a few weeks now but can't seem to find anything so I come here to ask for assistance. Right now I am doing everything via a very simple Google Docs spreadsheet.
I ...
0
votes
2answers
153 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
54 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
117 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
310 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
110 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
...
4
votes
3answers
5k 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
68 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
212 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
437 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
683 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
59 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
44 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
2answers
315 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
904 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
10answers
3k 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?
2
votes
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
2k 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
796 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 ...
4
votes
2answers
7k 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
293 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 ...
