# Tagged Questions

**0**

votes

**0**answers

57 views

### Google docs SpreadSheet get reuslt from a formula inside a formula

I was trying to obtain the result of a formula that is inside of another formula.
| A | B | C | D | E |
| Option1 | D2-(D2*10%)| | 10 | Result |
| Option2 | ...

**0**

votes

**1**answer

78 views

### Are spreadsheet programs inherently unsuitable for “one row=one case” data?

Often when I'm working with large data sets, I structure the data in a way where every row equals one specific case. For example, in a psychological experiment, I input the data so that all data ...

**0**

votes

**1**answer

372 views

### Copy distinct values in excel from one range to another

Suppose I have a table like this:
A B
food 12
cars 30
cars 40
food 10
food 14
living 100
fun 30
food 40
I'd like to copy all distinct values from column A to some other ...

**-1**

votes

**0**answers

741 views

### Google Spreadsheets Error: All series on a given axis must be of the same data type [closed]

I am trying to use embed interactive column charts from Google Spreadsheets for a website. However, when I enter the HTML code into the website I get the following error:
"All series on a given axis ...

**4**

votes

**1**answer

248 views

### Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file.
Basically, I'm looking ...

**1**

vote

**1**answer

3k views

### How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1
Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value.
I don't want the C-column. ...

**0**

votes

**0**answers

86 views

### Place multiple columns onto one line [duplicate]

Let's say I have a table in a spreadsheet that works like a calendar:
Jan Fev Mar ...
1 5 7 1
2 3 4 9
3 8 3 1
4 2 9 0
5 2 1 2
...
And so on...
I need to make a chart ...

**0**

votes

**1**answer

605 views

### Reference whole sheet in another sheet - reference dynamically NOT copy + paste

I have multiple sheets relating to each room in a house, I also have a master sheet showing the overview of the whole house, what id like to do is pull all the data from the room sheets into the ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

613 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?