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 (1)

0
votes
3answers
2k 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 ...
4
votes
2answers
2k 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
2answers
59 views

Google Docs / Excel how to transform redundant row in columns

I have a list of redundant rows like this See my Google sheet Target FRBBED05517 Job state EXECUTION_ORDERED Target FRBBED05523 Job state EXECUTION_ERROR Target ...
0
votes
2answers
209 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. ...
2
votes
1answer
262 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
1answer
37 views

AVERAGEIFS values that are not NA

I have the following AVERAGEIFS that averages column I grouped by the values in column B = AVERAGEIFS(B:B, A:A, A:A) Problem is, sometimes, the column B sometimes contains an NA() error. How do I ...
1
vote
1answer
37 views

Populate Spreadsheet with files within a folder

I need to manage a lot of files within folder related to a project, at the moment these files reside in Dropbox. So, I will like to find a way in which I can have a Spreadsheet populate itself with ...
1
vote
1answer
84 views

How to convert to insert mode when editing formulas on Google Spreadsheets?

Google Spreadsheet forces you to be in overtype mode whenever you edit an existing formula. The only way out I know is to type gibberish. That is, for how every many characters you want to insert, ...
1
vote
1answer
394 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
1answer
523 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
1answer
488 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 ...
0
votes
1answer
19 views

Is there a way to make a single bar chart that tracks color based on date in Google Sheets or Excel?

I've attached an image that's the best way to describe it. As the date increases from left to right, a different color for that range is displayed. Some sample data: Date Temperature Week 1 ...
0
votes
1answer
43 views

Using ARRAYFORMULA to auto populate a column for rows that contain data

The title just about says it all. We have a spreadsheet that has a date in Column A and then in Column B it compares the value of Column A with today's date and spits out the number of weeks between ...
0
votes
1answer
33 views

I have a list of names, and tags per row (each tag is in a new column), how do I get a pivot of names per tag

My data is set up in such a way where I have John alpha beta gamma Mary beta gamma upsilon Zack upsilon alpha omega What i get is only the first column of data... name Alpha ...
0
votes
1answer
53 views

Google Spreadsheets: how to generate a report for the most commonly used words

I have a google spreadsheet, I use to log programs that occur in my work everyday, I have a column, I use to register the names of each individual issue. What I want is to somehow generate a report ...
0
votes
1answer
131 views

How to convert a duration into a number of hours in Google Spreadsheets?

Trying to organize a timesheet. I have a cell with a duration of, say, 84:30:00 (84 hours, 30 mins, 0 seconds), which has a number format of "Duration". How can I calculate the total number of hours (...
0
votes
1answer
52 views

Total Unique items in col B for user ID x

Tried everything i can think of that google suggests, will copy and paste a few here for review, but simply put. I have a string of text as an ID say "id-1" I'm trying to count the number of unique ...
0
votes
1answer
78 views

How to highlight cells with formulas in Google Spreadsheet

Is there a way to highlight all the cells containing formulas (in contrast with raw numbers) in Google Spreadsheet? Thanks.
0
votes
1answer
661 views

Fetch Google Sheets data with Excel Power Query

I am using Excel 2103 and Excel power query. The fetch data from web works fantastically on most websites, however I cannot get it to work on Google Sheets I have tried using the share URL as well ...
0
votes
1answer
129 views

Microsoft Excel: Merge two sheets and dedup

I have a pretty simple question and google can't seem to return what I'm looking for. Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
0
votes
1answer
113 views

Run formula from different sheet

Can you run formulas from different sheets? (not simply showing the formula as a string/static text) Say I type =Sheet1!A1 where in that cell I have a formula =concatenate(ice&cream) ...
0
votes
1answer
141 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
1answer
33 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 38.70%...
0
votes
1answer
180 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
22 views

How do I count the number of “+” in a function in google spreadsheet?

So my function in A1 is 0,5+0,5+0,1 What I want to do is make a formula in B1 that counts the number of "+" elements in A1, how can I do this in google spreadsheet?
-1
votes
1answer
107 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 ...
2
votes
0answers
252 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 ...
2
votes
0answers
188 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 ...
1
vote
0answers
125 views

Shortcut keys in Google Sheet don't work?

Background: I have version 45.0.2454.85 m of Chrome (the latest when writing this question). I have a Swedish version of Logitech MX 5500 physical wireless Bluetooth keyboard. Problem: My problem is ...
1
vote
0answers
213 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
0answers
9 views

Create a student contact directory using google sheets?

I'm planning to create a spreadsheet containing the following student details: names, chosen subject, group letter, time slot, student bio, student cover letter. I would like to know if there is an ...
0
votes
0answers
34 views

List of Subfolder names and file links in google sheets - script

so I'm trying to get a google sheet list of file links in folders and subfolder which I'm keeping in google drive. it should look something like this: one main folder with a couple of subfolders ...
0
votes
0answers
14 views

How to autofill the same date down a column in Google Sheets?

I'm using google sheets to work on a spreadsheet, there are values in columns A-M. In Column A, there is a date. This date changes about every 400 rows or so (it doesn't change by a consistent number ...
0
votes
0answers
26 views

Google Sheets - Selecting latest date across multiple columns for a row that matches a criteria

Here is the spreadsheet setup Now I'm creating a report where I can enter the Member_# in cell K1 and the latest date from columns D, F, and H appears in cell K2 as well as the test label from the ...
0
votes
0answers
11 views

How do I get the index, within a range, of a cell containing a substring `x`?

How do I get the index, within a range, of a cell containing a substring x? I tried having a look at match, but that seems to require the match to contain the entire searchstring. I also had a look at ...
0
votes
0answers
70 views

Excel - Decision-Tree Budget / Shopping List

I'm planning the purchase of a bunch of A/V equipment. There are lots of different options for where we might end up. Some of the equipment is base equipment, we need it no matter what. For some of ...
0
votes
0answers
88 views

Cleaning up data fetched from Google Spreadsheet to Excel

I've been trying to synchronize and build a local database with Excel data. I need to build the database and program to create user accounts, manage the packages, track and log the status of the ...
0
votes
0answers
26 views

How can I compare a student's first name, last name, and day of detention to identify what lunch period they have in google spreadsheet?

I have a google spreadsheet that auto-fills last names in column B, first name in column C, and day (not date) of detention in column F. In another set of columns I have the students' lunch period ...
0
votes
0answers
12 views

Value to drop-down objects?

I think I might be over-thinking, but since I have no experience with any kind of spreadsheet, I just don't know where else to turn. What I'm trying to do: I want a drop-down list and each object ...
0
votes
0answers
14 views

Depending Data Validation

I want to create a table with select boxes(dropdowns) where the content of the second select is dependend on the first select Producer | Product | ... I would like to avoid heavy if/else clauses ...
0
votes
0answers
19 views

Spreadsheet styling every X rows

In Google Spreadsheet, how can I change the background color at every X rows. For example, Let say I need every fifth row to be in gray background, I can I achieve this? I already know how to do ...
0
votes
0answers
33 views

Create formula on the fly with Google Spreadsheet

I want to add a formula to each row in a database; for example: =query(a1:c5,"select A,'=5') I want to see 5 and the cell, not '=5', or =query(a1:c5,"select A,B,'=regexpreplace(...)') ...
0
votes
0answers
91 views

Histogram of dates in Google Sheets or OpenOffice

I have a list of dates that I would like create a histogram of. date 5/21/2014 5/20/2014 9/16/2014 5/28/2014 6/8/2014 6/8/2014 5/28/2014 5/20/2014 8/11/2014 7/19/2014 8/11/2014 The chart's x-axis ...
0
votes
0answers
125 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 ...
0
votes
0answers
25 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
0answers
647 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 ...