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

**0**

votes

**0**answers

13 views

### How do I use weeknum when I have a date range in Google Spreadsheet?

I'm not sure if my title question is correct, but here is what I am trying to accomplish:
I want to create a formula that counts the number of allocated containers for a specific week in the year ...

**-1**

votes

**0**answers

16 views

### Google Spreadsheet COUNTIF in ARRAYFORMULA

I currently have this formula in column P, starting in P2 and continuing down the page,
=IF(A2="", "", COUNTIF(E$2:E2,"Rejected (overdue application)"))
=IF(A3="", "", COUNTIF(E$3:E3,"Rejected ...

**1**

vote

**1**answer

22 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

**0**answers

8 views

### How to put a dollar symbol before every column and row number in google spreadsheet

I have a big spreadsheet in google docs with many formulas like this: =MIN(C3;C4)/500+4. Now we need to add $ before every cell row/column to make it absolute. So, the formula should look like this: ...

**0**

votes

**1**answer

33 views

### Google docs - click cell to open data in popup

Is it possible to have a cell that just says "click me" or whatever, which opens a popup so you can see the full data? I want to keep all my data contained in one row per item, but one cell per item ...

**0**

votes

**0**answers

9 views

### Get YouTube video's view count in Google Drive/Sheets?

Is there anyway to write up a Spreadsheet in Google Drive such that a cell will have the current (or as close to current as possible) number of views that video has received?

**0**

votes

**1**answer

26 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

173 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

42 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

18 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

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

**5**

votes

**2**answers

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

**0**answers

17 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

37 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

28 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

516 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

168 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

40 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

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

**0**

votes

**0**answers

65 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

33 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

39 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

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

**19**

votes

**5**answers

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

51 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

118 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

29 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

43 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

29 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

65 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

64 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

723 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

5k views

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

How to freeze more than 5 column in google spreadsheet?

**-1**

votes

**1**answer

488 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

**0**answers

130 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

**1**answer

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

**1**

vote

**0**answers

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

**3**

votes

**6**answers

8k views

### Where can I find some dummy data to teach my friend how to use a spreadsheet? [closed]

In particular, tabular data that can be graphed. What's your favorite source of interesting data?

**0**

votes

**0**answers

236 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

**1**answer

320 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

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

vote

**2**answers

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

**-1**

votes

**1**answer

200 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

**1**answer

135 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

108 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

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