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
0answers
13 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 ...
1
vote
1answer
23 views

Creating a table similar to pivot table

I'm not sure how to explain it, but I hope this example makes it clear. Data: Yes/No | Place1 | Place2 | Place3 ---------------------------------- Yes | Thing1 | Thing2 | Apple No | Apple | ...
1
vote
0answers
21 views

Google Sheets: Asterisk character (no wildcard) on conditional formatting [migrated]

I have a sheet with following values on column A: [ A ] [1] Dead line [2] 15 days remaining*** [3] Dead [4] 131 days remaining* [5] 80 days remaining** I would like to use ...
0
votes
0answers
10 views

Google Sheets: How to print information of user that is printing [migrated]

Well, I am creating a sheet on Google Sheets and I will share it with some people. The users online can see its contents, but, to maintain the data update information when someone prints that, I ...
0
votes
0answers
10 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
1answer
15 views

Summing the above 7 rows in same column based on a value

I have a series of values that repeat like days of the week doing down in the same column. Monday : 2 Tuesday : 5 Wednesday: 6 Thursday : 1 Friday : 8 Saturday : 12 Sunday : 4 Monday : 3 ...
-2
votes
0answers
41 views

Google sheets/excel array formula return row of values based on =TODAY()

I am collecting data from a Google form to a spreadsheet and then capturing that information into a 2nd spreadsheet for manipulation. From here I want to display the same information on a 3rd sheet ...
2
votes
2answers
85 views

Extracting email from text string in excel/google spreadsheet

I'm looking to extract email addresses from text strings in Google Docs/Excel and email them automatically, where the content of the cells are currently unknown (until updated by user). For example, ...
0
votes
1answer
10 views

Format as currency within a formula

I am trying to sum a column of dollar amounts and label it as "Total: $xx,xxx.xx" in the first row of that column. I have gotten as far as ="Cost - " & Text(SUM(B2:B), "$0.00") BUT, it is not ...
0
votes
1answer
25 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 ...
2
votes
1answer
23 views

Excel autonumber range

Most of you know about this little feature of Excel, as well as almost any other spreadsheet software like Google Spreadsheets called Autonumbers. Example. What I'd like to know if it's possible to ...
2
votes
2answers
40 views

How to create a data series for exponential decrease diagram

I want to create a pricing model this way: If you need this product for 50 people, you should pay 2500 (units) per person. . . . . If you need this product for 10,000 people, you should pay 300 ...
0
votes
0answers
15 views

Google drive spreadsheet is showing black shadow on while typing letters

I mm using Google drive spreadsheet. It is showing a black shadow while typing letters in excel. How do I resolve this?
1
vote
1answer
21 views

Count number of cells that match certain criteria with formulae

Suppose I have column with dates: 2015-01-10 2015-08-12 2014-01-02 2015-01-28 2016-10-14 I want to count how many dates fall to January. I would supopse that formulae is like this ...
0
votes
1answer
12 views

Excel - Signs in different columns

Given I have put by signs in a different column, making my data look something like: How do I write a function to get the sum of these values (=198) with taking the signs into consideration?
0
votes
0answers
26 views

Cell formatting in Google Spreadsheets does not get preserved

My Google Spreadsheet does not preserve some formatting. Every time I set, for example, font size to 12 for the whole sheet, newly copied data uses a smaller font size. This only started being an ...
0
votes
1answer
37 views

Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function. What I need to do is use this formula in google sheets for ...
0
votes
1answer
76 views

how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e F1:F100,J1:J100,N1:N100 for each row i'd like to highlight the cell with the maximum value. i tried ...
1
vote
1answer
21 views

How to make a formula to calculate how many of each unique item are in a column in the last 365 days

I have two columns A:A (dates) and B:B (items) ..... I need to find a formula to calculate how many of each unique item are in column B : B in the last 365 days. In the example the right value in the ...
0
votes
1answer
53 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) ...
1
vote
1answer
300 views

Copy every nth column on a specific row from one sheet to another (in Google Sheets)

I want a function to select every 2nd column on a particular row and display it in another sheet. I have two sheets: Sheet1 and Sheet2 In Sheet1 A2 I have a list of numbers that start from 1 to ...
0
votes
0answers
39 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
2answers
38 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 ...
1
vote
0answers
23 views

Where does the calculation take place? [closed]

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 ...
2
votes
1answer
175 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 ...
0
votes
1answer
75 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
2answers
130 views

Is there a tool to put a phone number into E.164 format?

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
1answer
44 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. ...
0
votes
2answers
62 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
2answers
86 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
0answers
651 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
1answer
528 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 ...
0
votes
1answer
542 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. ...
1
vote
1answer
2k 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
1answer
32 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
4answers
2k 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
2answers
63 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
0answers
53 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
1answer
65 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
0answers
75 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
0answers
155 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
0answers
84 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? ...
0
votes
1answer
29 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
1answer
180 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
592 views

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

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 ...
2
votes
2answers
436 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 ...
0
votes
0answers
24 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 | ...
1
vote
2answers
819 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 ...
0
votes
1answer
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 ...
0
votes
2answers
42 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.