Google Spreadsheets is a part of the Google Docs web app suite. Questions about Google Spreadsheets are off topic and should be asked on webapps.stackexchange.com, unless they specifically involve your computer or browser.

learn more… | top users | synonyms

1
vote
0answers
10 views

Adding a null to google sheets cell validation

In my Google Sheet i have cells that need validation. Users can pick from the drop down list and all works well. My users also need to be able to revert to an empty cell. Ie going back to an empty ...
-2
votes
1answer
35 views

How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging: Date Running (minutes) Pushups Pullups Crunches and the rest of my workout entries. I insert my achievements each day. How can I script Excel to ...
0
votes
0answers
13 views

Google Docs Spreadsheet Export Statistics

I have a spreadsheet exported from JotForm.com but I want to export that spreadsheet to a "diagram" or to page that gives me the statistics of the form. I know you can do that just if you link that ...
0
votes
1answer
38 views

Share cost of activities between participants in spreadsheet

Say you have a spreadsheet you use to fairly share the cost of activities between people (example google doc): A B C D E 1 Activity Cost User1 User2 User3 2 1 ...
1
vote
1answer
27 views

Formula works in excel and not in Google Spreadsheet

The following formula works in Excel but not in Google Spreadsheet: =INDEX(Sheet1!B1:P1,MATCH(MAXA(Sheet1!B11:P11), Sheet1!B11:P11,0)) Would there be alternatives? Thanks, Bing
0
votes
1answer
41 views

Google Spread sheet-pulling down formulas is returning an error message

In Google Spread sheet. I need a formula that will add columns C-J and give me the total in column M. I entered =SUM(C5:J5) as a function in column M5 When I go to drag it down (using the lower ...
0
votes
1answer
65 views

How can I do this in spreadsheets?

Let's say you have a table like this: | A | B | C | ------------------------------------- 1| sex | age | answer q1 | ------------------------------------- 2| ...
1
vote
2answers
27 views

How focus on the document after find?

I'm filling a column after finding a row via a search on the name column. So I do CTRL + F, type the name, and click the the cell with mouse to fill it. Is there a way to do this without using the ...
1
vote
1answer
80 views

Google Spreadsheet. Retrieve only one cell from ImportData-result [closed]

I have this function: =ImportData("http://ichart.yahoo.com/table.csv?s=AAPL&a=0&b=7&c=2013&d=0&e=7&f=2013&g=d&ignore=.csv") ...which returns how a given stock was ...
2
votes
1answer
56 views

How to look a value and sum it into a certain cell

I have 2 columns, Space & Rows. I want to iterate over the Rows columns and sum only the corresponding value of Space into a certain cell within the same page. The pseudo code for this would be ...
2
votes
3answers
398 views

In a spreadsheet, is it possible to separate rows into groups that will not change order when filtered?

I am trying to make row subgroups in my spreadsheet rows so that I can sort my data but have rows in any particular subgroup stay together. This is probably easiest to show with a picture. Sorting ...
0
votes
0answers
78 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
0
votes
3answers
333 views

Find matching value in a row and return column name II

My qeustion is similar to, but different from Find matching value in a row and return column name? I have a spreadsheet with two tabs: Tab A has one column which is a list of email addresses (there ...
1
vote
3answers
94 views

Generate an alphabetic index from a spreadsheet

I have a text file of lecture topics from my physics class that looks like this: 1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,, 1/16,Lorentz transformations,Velocity ...
1
vote
1answer
73 views

HTML tags in Google Spreadsheet

I am experiencing issues with Google Spreadsheet. The thing is that me and my colleagues are using one spreadsheet as a table for translations, there is a column for English and then German and ...
2
votes
0answers
102 views

Merging CSVs with some common columns (though columns are in different places)?

I'm looking to merge CSVs that have common columns, but the columns aren't always necessarily in the same place. The CSVs do have a header row. I just want to try to get the data appended to the ...
0
votes
0answers
271 views

How to Analyze the Trend of Data In Google Spreadsheet and Excel

I am using google spreadsheet to gather survey data: The spreadsheet looks like this Timestamp Choice Comment 1/15/2013 4:24:29 A Comment goes here 1/15/2013 4:24:32 B ...
0
votes
3answers
490 views

How can I replace tab-delimited data with line breaks?

I have a lot of tab-separated data, and this means when I import that I'm getting a lot of columns (too many for Google Drive and OpenOffice). I think what I need to do is find and replace all tabs ...
1
vote
3answers
888 views

What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]

I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...
5
votes
5answers
759 views

Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
1
vote
1answer
213 views

Can I add rows to a Google Drive spreadhseet from a local text file?

Is there a way to automatically add rows to a Google spreadsheet documents by editing a local text file? Maybe via DropBox or GoogleCL?
1
vote
2answers
6k views

Pull row of data from one place in spreadsheet to another

I have a list of names and their assorted properties. I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it. Currently I can ...
0
votes
2answers
532 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
1answer
201 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 ...
3
votes
1answer
3k 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
758 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 ...
1
vote
2answers
2k 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
2answers
308 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
1
vote
1answer
298 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 ...
12
votes
5answers
36k 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
102 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
1answer
359 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 ...
1
vote
2answers
2k 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
2answers
623 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
2k 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
9k 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
2answers
3k views

How to freeze more than 5 column in google spreadsheet?

How to freeze more than 5 column in google spreadsheet?
2
votes
5answers
4k 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
4k 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
3answers
1k 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 ...
2
votes
1answer
556 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 ...
6
votes
1answer
1k views

Date based sum in Excel / Google Docs spreadsheets

I have a bunch of rows with a date and a dollar amount (expenses). I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the ...