**1**

vote

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**3**answers

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

**3**answers

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

**5**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**5**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**10**answers

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

**2**answers

3k views

### How to freeze more than 5 column in google spreadsheet?

How to freeze more than 5 column in google spreadsheet?

**2**

votes

**5**answers

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

**4**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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 ...