**0**

votes

**1**answer

14 views

### Reference a cell with input from another cell

The final objective is to reference the last populated (higher row number) cell from a column (its value).
I found a function that returns the row number of the last populated (higher row number) ...

**0**

votes

**0**answers

6 views

### Google Sheets: Select Sheet to print from [migrated]

Now sure if this is possible but here we go...
I have a "workbook" with multiple sheets. Each sheet is a schedule for the week for employees with a bunch of math stuff to help a general manager see ...

**0**

votes

**0**answers

15 views

### How do I post a value from Google Spreadsheets to Slack twice a day at preset times? [migrated]

I have a Google spreadsheet that I constantly update and I'd like to set certain times of the day, say 8am and 4pm, to automatically read the value in certain cells and post them to a channel on ...

**0**

votes

**0**answers

17 views

### Google Spreadsheets Automatically Add Border [migrated]

I'm looking to have cell borders automatically applied when a cell is not empty. I thought I could use conditional formatting for this, but it doesn't seem to be an option. Any recommendations?

**0**

votes

**0**answers

9 views

### Google slides with linked data from Google sheets? [migrated]

Is it possible to link a Google sheets worksheet with a Google Slides presentation table?

**0**

votes

**0**answers

9 views

### How do I set my Google Sheet up to create a running list of data from another Google Sheet? [migrated]

I am attempting to create a master calendar in Google Sheets that my department can use to add appointments to. I know I can grant them access to my calendar to add these appointment directly, ...

**-1**

votes

**0**answers

8 views

### Get rid of template info of copied template [migrated]

I made a copy of a template but every time I download it there is a 3rd sheet saying this is a template.
how can I get rid of this?

**-1**

votes

**0**answers

15 views

### Google sheets function [migrated]

I have two columns a and b
a contains a set of text and
b contains a set of numerical that relates to each row in a
I want to create a function that will search column a for substring value and ...

**0**

votes

**0**answers

33 views

### How to download google sheets? [migrated]

What are ways to download a google sheet that you were given access to but don't own.
On https://docs.google.com -- Is there a chrome extension or anything like that?
Thanks.

**-2**

votes

**0**answers

19 views

### I need to know the answer to a formula [migrated]

I have a question, I've got a bunch of cells that have formulas to display the day of the week according to the date above it. (I'm using google sheets by the way)
I want the cell underneath the day ...

**0**

votes

**0**answers

12 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

**0**answers

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

**0**

votes

**2**answers

45 views

### (Google Sheets/Excel) SUMPRODUCT but ignore empty cells

I'm building my girlfriend a Google Sheets spreadsheet that will allow her to automatically compute her students' grades based on grades she gives her students on different projects, exams, and ...

**0**

votes

**1**answer

36 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

**1**answer

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

**0**

votes

**0**answers

16 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

**1**answer

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

**2**answers

239 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

**1**answer

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

**1**answer

34 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

**1**answer

25 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

**2**answers

50 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

**0**answers

21 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

**1**answer

26 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

**1**answer

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

**0**answers

30 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

**1**answer

48 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

**1**answer

175 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

**1**answer

22 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

**1**answer

60 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

**1**answer

433 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

**0**answers

51 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

**2**answers

40 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

**0**answers

32 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

**1**answer

181 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

**1**answer

77 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

**2**answers

153 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

**1**answer

61 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

**2**answers

69 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

**2**answers

98 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

**0**answers

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

642 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

**1**answer

667 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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

64 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

55 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

69 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

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