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

0
votes
0answers
3 views

Google Sheets Suffix To Column Cells [migrated]

I'm editing a spreadsheet of product data that has a category column. I'd like to create a new "Left Handed" as well as "Right Handed" category in addition to each products current categories. I've ...
0
votes
1answer
11 views

How I hide the chat window in Google Drive Spreadsheet?

I sometimes accidentally open the chat window when using Google Drive's Spreadsheet app. I couldn't figure out how to close it. Any ideas?
0
votes
2answers
19 views

Show image in cell based on cell value

I am creating a weekly income comparison table. I want to compare A5 and A10 cells and display appropriate image in B7 cell. The image will be either UP or DOWN arrow (which reflects increase or ...
0
votes
1answer
32 views

Does Google Spreadsheets no longer support the OpenDocument Spreadsheet format?

I tried to upload an .ods file from my computer to my Drive and (surprisingly) I couldn't open it with Google Spreadsheets; so I proceeded to Google a little and I found out that it actually is ...
0
votes
1answer
46 views

How do you do a conditional format for a date range in Google docs?

I have a list in a spreadsheet of upcoming game releases. I'd like to do conditional formatting on the Release Date field so that if the game is being released this month / week, I can have different ...
-1
votes
1answer
76 views

Common values in three columns of data in Google Spreadsheets

I have three columns of data in columns K, M and O in a Google Spreadsheet and want to find out (with results printed in column H) which values are common to each of K,M and O. To make it simpler, I ...
0
votes
0answers
38 views

Get definition and examples of list of words by Google translate?

I saw this answer of Alternative to Google Translate API? that describes how we can translate list of words by inserting them in 'Google spreadsheet'.But how I can get definition or examples of a ...
0
votes
1answer
102 views

Insert text to the beginning of every Cell in a Column

I'm trying to find a way to insert text in to every Cell in a specific Column. e.g. Column C has 50 rows: I need to insert 0049 to the beginning of every Cell. I didn't had any luck finding/creating ...
0
votes
0answers
187 views

“Array result was not expanded because it would overwrite data”

I'm trying to use Google Spreadsheets but I get this error when an IMPORTXML would overwrite some rows of cells that already has something in them: Array result was not expanded because it would ...
0
votes
1answer
208 views

Returning row values based on specific variables across multiple sheets

I'm not entirely sure how to properly explain this, but here we go... I'm trying to create a single budgeting document that allows me to manage purchasing and reconciliation for multiple projects. I ...
1
vote
0answers
48 views

How to chart time of day in Google Spreadsheet with midnight crossover?

I'm struggling with the best way to chart a series of times in Google Spreadsheets that involves a midnight crossover. The data in question is a graph of a bedtime, when the time to bed is after ...
0
votes
0answers
95 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 ...
-3
votes
1answer
115 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
36 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 ...
-1
votes
1answer
95 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 ...
0
votes
1answer
54 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
83 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 ...
-1
votes
1answer
84 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
29 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
109 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
69 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
1k 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 ...
2
votes
0answers
103 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 ...
-1
votes
3answers
735 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
102 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
82 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
111 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
343 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
627 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
1k 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
836 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
265 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
11k 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
593 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
246 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
5k 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
918 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
345 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
446 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 ...
16
votes
5answers
48k 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
103 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
388 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
3k 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
657 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
11k 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
3answers
4k views

How to freeze more than 5 column in google spreadsheet?

How to freeze more than 5 column in google spreadsheet?
2
votes
5answers
5k 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?