**1**

vote

**0**answers

14 views

### Where does the calculation take place? [on hold]

In Google spreadsheets, I have quite a big amount of relatively complex array formulas in many cells. That takes ages to complete calculating.
Does the speed of calculation depend on my PC ...

**0**

votes

**0**answers

18 views

### Sum rows of a array function that outputs a matrix [Google Spreadsheet] [migrated]

I got a arrayfunction that is returning a matrix. I want to edit this to only return a vector, where this vector contains the sum of each row. I tried applying sum(), but that summed every element of ...

**1**

vote

**0**answers

12 views

### Google Spreadsheet limit ArrayFormula

I'm using ArrayFormula to calculate multiple ranges and its slow because its trying to calculate everything in that range even though it has nothing in it. Is there a way i can limit the ArrayFormula ...

**0**

votes

**0**answers

14 views

### how to make columns not affect other columns within the same row in google spreadsheet [migrated]

I have done an schedule in google excel(google spreadsheet). I set text wrapping to wrap. The problem is that when i write something in column A and the row in column A gets expanded to fit all text ...

**0**

votes

**0**answers

17 views

### Update formula ranges when adding new rows to a spreadsheet [migrated]

I have a Google Spreadsheet in which I keep a list of expenses. I add a new expense by inserting a new row above the last expense. On the first row of the spreadsheet, I keep a sum of all expenses: ...

**0**

votes

**0**answers

5 views

### How to get historical currency data in Google spreadsheets? [migrated]

I use this formula to get the currency:
=GoogleFinance("CURRENCY:EURUSD", "price", DATE(2006,10,2))
But when I enter a date before 2006-10-2 I get an error, is there any way to get older data when ...

**0**

votes

**1**answer

39 views

### Strip non-numeric characters from a phone number in spreadsheet

I'm looking for both a quick and dirty, as well as easily repeatable, solution to strip non-numeric data from a column in a spreadsheet for import to a MySQL database. Example:
(123)456-7890 fred ...

**0**

votes

**0**answers

5 views

### Filter from multiple sheets into graph using Google Spreadsheets [migrated]

Context
I've got a big travel expenses spreadsheet.
In it, I have daily entries for different expenses labelled with things like
Date
Currency
Ammount
Exchange Rate
Amount in £ (my native ...

**0**

votes

**0**answers

3 views

### How to display Image from URL in Google Sheets? (and apply it to multiple rows) [migrated]

So I created a list of members in Google Sheets, each member having a profile image, name, location, etc.
I exported this list from import.io, a data extraction tool. The only problem is that when I ...

**2**

votes

**1**answer

147 views

### Select all cells in a row

How can I select all cells in a row in Excel / Google Spreadsheet?
I know I can select all cells in a column using
A:A
But how can I select all cells in a row?
This doesn't work:
1:1 // select ...

**6**

votes

**3**answers

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

**0**

votes

**1**answer

69 views

### Excel table: Add only certain values (Oscar predictions ballot)

So for tonight, me and friends made a spreadsheet with oscar nominations and predictions of winners. What I'm trying to achieve is that I just put a '1' or an 'x' or something behind the winner in ...

**0**

votes

**1**answer

33 views

### Spreadsheet finding and sorting most frequent appearance of names

I have a spreadsheet that looks like the following:
https://docs.google.com/spreadsheets/d/1BN3GNRFCsBeHu9gQaKzIo7bfFRkcDqMJ6VMtidEwPD4/edit?usp=sharing
There is a set list of names in Column A. ...

**0**

votes

**2**answers

39 views

### How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email).
Q: How can I ...

**0**

votes

**1**answer

19 views

### Combine GoogleSheets functions

I'm trying to combine multiple functions into one formula in GoogleSheets spreadsheet.
I've tried learning more from Google's Help center and through YouTube but didn't came to satisfactory result.
...

**1**

vote

**3**answers

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

**1**answer

117 views

### How to increment cell references by 7 rows for each row dragged in Excel

In Excel 2007 and Google Sheets, I'm trying to drag a formula to populate cells in a column, but I need each successive row to have the cell references incremented by seven rows. For example, drag ...

**2**

votes

**0**answers

158 views

### “Trying to connect” error in Google Docs on Safari

Beginning a few months ago, I started receiving a significant number of "Trying to connect" errors when using Google Docs in Safari.
I can load the page fine, and I can even start using it, but ...

**0**

votes

**1**answer

117 views

### How to combine data set to create unique combinations [duplicate]

First of all I don't have experience with Excel scripting, just basic formulas. I've seen this other question on SU but I'm not sure if that's exactly what I need or how to adapt it to my needs.
...

**10**

votes

**2**answers

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

**1**

vote

**1**answer

395 views

### How do I copy rows based on single cell value in Google Sheets?

I have two sheets in Excel, which is duplicated on Google Sheets. Sheet 1 is a list of names with various bits of information for example
Name Number Outcome
Colin Smith ...

**0**

votes

**1**answer

30 views

### organizing columns in excel into standard format

I have data in a excel spreadsheet in a regular pattern that needs to be organized in a format friendly to statistical analysis.
Here is the format:
Clinton 29.30% 22
Edwards ...

**1**

vote

**4**answers

752 views

### Count the number of rows with equal values in two specified columns

I have two columns in MS Excel/LibreOffice Calc/Google Spreadsheets with numbers. I would like to count the number of rows which have identical values in both columns.
In the following example:
...

**0**

votes

**2**answers

48 views

### Excel - What's the best conditional formula when there are lots of conditions?

In Column A on my data set there are group identification numbers. They are integers ranging from 0 to 30.
In Column B is my data.
The groups form 10 cohorts, and the cohorts don't map onto the ...

**0**

votes

**0**answers

39 views

### Excel/Google Sheets: NETWORKDAYS() over a filtered range

I'm currently cleaning up a Google Sheet, which due to increasing size needs to be condensed a bit. I'm currently working on removing 14 columns with basically the same formula, but am having problems ...

**-1**

votes

**1**answer

42 views

### Find the highest number from multiple columns and return a name

I'm a complete novice at spreadsheets. I have created this spreadsheet by reading a lot of forums and muddling together formulas. I have now hit a problem that I can neither fix nor find out how to ...

**0**

votes

**0**answers

34 views

### Export cropped HTML table from google spreadsheet

I only need the actual table exported from a Google spreadsheet. Cropping the HTML from HTML export manually means lots of work.
This document contains two tables, and these must occur in different ...

**1**

vote

**0**answers

80 views

### ArrayFormula + Average giviing me div/o error

I have the formula on B2
if(D2="", "", AVERAGE(D2:AF2))
This gives me the average of all numbers in the row, and takes off the ugly error when there is no numbers. I tried spreading this formula to ...

**0**

votes

**0**answers

62 views

### Google Sheets: Count the number of consecutive blank cells in a row and alert if it matches a set number

In the attached sheet, I would like to return a red coloured cell as an alert in column B if there are 3 or more consecutive blank cells across the row.Is this possible?
...

**1**

vote

**1**answer

810 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

**1**answer

27 views

### How to make lists of tagged data

I have created a Google Spreadsheet of tagged data and I am trying to make different lists based on the tags. For instance, I would like to see a list of media, health and eyes records. From the data ...

**1**

vote

**2**answers

405 views

### Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet.
First Sheet:
(yes I need these merged cells)
Second Sheet:
Unfortunately Google ...

**1**

vote

**0**answers

66 views

### Equivalent for FILTER() formula in Libre Office

In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell.
=FILTER(Sheet1!A2:E, Sheet1!E2:E > 0)
This gives me all the rows in the Sheet1 from row ...

**0**

votes

**1**answer

213 views

### How do you do a conditional format for a date range

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

vote

**0**answers

168 views

### Remove line breaks within cells in a range (\n) by Google Apps Script

In a Google Spreadsheet I would normally do the following:
Go to Find and Replace
Check "regular expressions"
Find \n and replace with null
I have searched and for the life of me I'm unable to ...

**0**

votes

**2**answers

35 views

### Double column value in a spreadsheet

I need to double the value of a column (ex: C) into another (ex: F) for every row in a spreadsheet.
How can I achieve this?
This is probably simple, but I can't get my head around it.
Thank you.

**1**

vote

**1**answer

96 views

### Convert duration text to duration value

I need help on Google Sheets/Excel.
I extracted sports results data with the IMPORTHTML function of Google Sheets.
All the cells in the Result column contain a duration in the form of "m:ss.00" but ...

**1**

vote

**1**answer

160 views

### Pad numbers to specific length in Google Spreadsheet

I have a column with integer numbers like this: 1, 2, 3, 4, 5 and I want to create another column with these values padded to length of three like this: 001, 002, 003, 004, 005.
Is it possible to pad ...

**25**

votes

**5**answers

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

**0**

votes

**0**answers

23 views

### Merging Data from a Spreedsheet into an e-mail template

I'm trying to find an application of sorts to help me extract data from a spreadsheet and then display that data into an e-mail form
e.g.
Spreedsheet data.xls
Field 1 | Field 2 | Field 3
Data | ...

**0**

votes

**1**answer

55 views

### Spreadsheet data checking columns

I am trying to separate datas from columns(A,B&C) based on datas from an index table at columns (E&F)
I need to list only those data from columns A/B/C when column B data has no corresponding ...

**2**

votes

**3**answers

2k 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

**1**answer

183 views

### Major FIREFOX Redirect Error Problem (Error Code 11156)

I would appreciate some help please. When I try to log into some website, im being redirected to the members only page (e.g. dashboard, main account, etc) but instead of successfully landing there as ...

**1**

vote

**1**answer

37 views

### How to xml to xml parse

I am trying to automate this process.
I have link to this xml file. it has many parameters, but I am only interested in 3 of it's parameters. I want to use those 3 parameter and create new xml file ...

**0**

votes

**1**answer

71 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

**2**answers

41 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

**1**answer

72 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

78 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

**1**answer

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

**3**

votes

**3**answers

7k views

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

How to freeze more than 5 column in google spreadsheet?