People who code: we want your input. Take the Survey

Questions tagged [google-spreadsheets]

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.

Filter by
Sorted by
Tagged with
18
votes
5answers
75k 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 ...
2
votes
1answer
28k views

How to create a graph with two Y axis with different values in Excel

How do you make a scatter graph with 2 Y axis (one on the left and one on the right)? I have 2 scatter graphs that I want to combine. I need to have 2 lines, both lines have the same dependent ...
0
votes
1answer
4k views

Countifs by consider dates range [closed]

I have a formula which is like this =COUNTIFS('sheet1 '!W:W,">0",'sheet1 '!A:A,"Truck") which is count all data in column W (sheet1) larger than 0, which are called Truck in column A. Now, I want ...
-3
votes
1answer
241 views

How to find the formula for exponential growth in excel?

I am working on this. Can anyone please help me?
3
votes
5answers
14k views

Count substring occurrences within a cell

How can I count the number of occurrences of a substring within a cell? For example: | | A | | 1 |John,John,Tom,David| What formula would I use if I want to return the number of ...
1
vote
1answer
55k 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
2answers
25k views

Automatically import data into excel from Google sheets

I use the importrange feature to import data from one Google sheet workbook to another. Does anybody know if it's possible to import and populate a cell from a Google sheet workbook cell into an excel ...
3
votes
2answers
84 views

I want to count IF both condition are true Logically count by AND excel

I have two Columns both are categorical columns. Like Age_group and Engagement_category. And I want to get count no. of each engagement_category in each Age_group. | Engagement_category | Age_group | ...
1
vote
1answer
57 views

Counting from & to specific dates & times on a spreadsheet - mostly done, but some bugs

I wanted to make a spreadsheet that I could enter a date & time and calculate how much time (in years/dates/months/weeks/hours/minutes/seconds...) I kept expanding on it. it serves very little ...
1
vote
1answer
150 views

EXCEL : Hyperlinked dynamic index

I found below formula to generate a dynamic index in spreadsheet. =IFERROR(INDEX(Sheet!$A:$A,SMALL(IF(ISTEXT(Sheet!$A:$A),ROW(Sheet!$A:$A),""),ROW(Sheet!A1))),"") Is there a way i could add ...
0
votes
1answer
2k views

Spreadsheet formula to count consecutive values in a column

I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this: Y Y Y N Y N Y Y the desired result would be 2 Y Y Y ...
0
votes
1answer
447 views

Aggregation of overlapping groupings in pivot table

I would like to aggregate a value of overlapping groups in a single pivot table. An example of my data is: Name, Value, Attribute 1, Attribute 2, Attribute 3 A, 1, True, True, True B, 2, True, ...
0
votes
1answer
583 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) ...
-2
votes
1answer
2k views

Exponential growth in excel [duplicate]

What kind of formula should I type in order to get these values? I know that this is exponential growth and growth rate is 0.42. I appreciate if someone can help me with this. Please see the picture