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
2
votes
1answer
45 views

CONCATENATE cells in a column IF condition in other colum is met

Using Google sheets (or Excel if Google sheets can't do it). I'm trying to concatenate any cell in B column, if its corresponding A cell is "include". The columns are very long and therefore ...
0
votes
1answer
21 views

Insert big text into multiply rows by keyword into Excel or google spreadsheets

If I have multiline text like Line: x1 = 10, y1 = 100 x2 = 30, y2 = 40 Line: x1 = 100, y1 = 120 x2 = 130, y2 = 140 And so on. Is it possible to insert it at once at Excel or google spreadsheets so ...
0
votes
0answers
14 views

Google SpreadSheets query: how to join “grouped by” cells in a list? [closed]

Suppose I have this table: | Name | Amount | Category | | name_1 | 10 | A | | name_2 | 2 | B | | name_3 | 3 | B | | name_4 | 6 | C | I know how to ...
1
vote
1answer
15 views

Excel/Sheets: Average only the input data in a range of data?

I've got an annual budgeting spreadsheet in which each month is listed along with given categories of items. I'm trying to find my average monthly expenditure on any given category, but don't know the ...
-1
votes
1answer
35 views

How do I access an open API like Ethereum with a spreadsheet like excel or sheets?

Is there a way to access the Ethereum API using either excel or sheets or some other database with a website front end? I'm trying to track my transactions.
0
votes
0answers
3 views

How can I get a list of Sheet2!A2:A cell values where (Sheet2!B2:B= “Yes”) and (Sheet1!B2:B less than 200) [migrated]

How can I get a list of Sheet2!A2:A cell values where (Sheet2!B2:B= "Yes") and (Sheet1!B2:B less than 200) (ignoring values that are in Sheet1!A2:A but not in Sheet2!A2:A) https://docs....
0
votes
0answers
6 views

Predict change to reach a percentage goal for multiple elements in Google Sheets [migrated]

I have a predetermined percentage distribution for a set of 5 elements, for example: A = 25% B = 15% C = 30% D = 20% E = 10% Then, I get all these elements in some other distribution ratios, for ...
0
votes
0answers
21 views

Importing Fair Value from simplywall.st via importXML to Google Sheets

I'm trying to import the fair value from https://simplywall.st/stocks/us/tech/nasdaq-aapl/apple via the importXML function in Google Sheets using the XPATH for the FV. The formula: =importXML("...
0
votes
1answer
262 views

SUMIF only for last condition row

I have a spreadsheet where I need to total values using a SUMIF function and record that total in another column, but I only want it to record that total for the last instance of a value in the column....
0
votes
0answers
21 views

Listing function points in a spreadsheet/excel [duplicate]

I am working on a Pre-Calculus Polar coordinate graphing project that incorporates some creativity; My current plan has me graphing the Nautilus Shell as my focal point. However, I have to list points ...
0
votes
0answers
16 views

How to get a vertical bar chart with the sum of rows grouped by month

I have a spreadsheet with over 300 rows, and in each row I have a Created At column with this date format: 20/Apr/21 5:34PM. I would like to have a vertical chart that is the sum of the rows for each ...
0
votes
2answers
34 views

Google Sheets / Excel - Create a minimum list based on multiple cells

I'm trying to get a minimum number (C) if A B and D combined match with any other row A B C D 1 iOS Safari 14.0 mobile 2 Android Samsung Internet 13.2 mobile 4 Macintosh Safari 14.0 desktop 5 ...
1
vote
0answers
27 views

Optimizing sales in excel/google sheets

I have a table that looks like that: investment p1 p2 p3 1000 100 50 80 2000 200 60 95 3000 300 70 110 4000 400 80 125 5000 500 90 140 6000 600 100 155 7000 700 110 170 8000 800 120 185 ...
0
votes
1answer
15 views

Using IF to apply different rounding rules based on value range - error with too many IF arguments

I am trying to build a formula that will round a value in a cell based on these requirements round to 0 if less than 2% round to the nearest 2% increment up to and including 10% round to nearest 5% ...
0
votes
0answers
42 views

How to apply Text cell format permanently on a google sheet's column?

I recently added IDs as Number in a column those are basically built as alphanumeric. Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...
0
votes
0answers
11 views

Check duplicate then copy $ cell next to duplicate

I have a large dataset with duplicates in multiple columns the only exception is that for every duplicate the cell (email) is different. I want to copy that email and place in the same row as the ...
0
votes
1answer
25 views

How to copy rows of specific columns based on a criteria (and then continuously update)?

I have 2 sheets, let's call them sheet 1 and sheet 2. In sheet 1, I have some data where essentially at its core its a Scoring tally, something like this: Name Age Gender Score Jack 12 Male 155 ...
1
vote
1answer
32 views

Get a drop-down list from another sheet based on lookup

I have a list of CA in my Source sheet that looks like this: And in my main sheet I need to get a dropdown list of "little a" for each CA, like this: Main sheet: Sheets: For example: ...
1
vote
1answer
35 views

How to calculate max sum held over a month?

I need help with a formula that needs to calculate the max sum held at one time for each month. In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
0
votes
1answer
27 views

Cant make Alt + some keys shortcuts in Google Sheet behave like Excel on some computers

In Excel we have some Alt shortcuts like: Alt - E - S - V: paste special value only Alt - I - R: insert a new row In Google Sheets they can also be used. When I press Alt + I for example, I see this ...
1
vote
0answers
14 views

Specific format on multiple cells depending on the values of other cells

Let suppose I have A1:C3 for instance that I want to have a specific format (for instance blue borders) depending on another value of the spreadsheet, for MWE, A5:C8. A5:C8 could be binary values and ...
0
votes
0answers
28 views

Copying names from one sheet to another based on 1 of 6 criteria in another cell

I have a google sheets workbook with 3 tabs. 1st tab is the main tab I'm pulling from I have a column for names and a column of states the users are from. 2nd tab is for all users from the West and ...
1
vote
1answer
41 views

Sum and lookup over range in spreadsheet

I have a google spreadsheet that looks like this Items Item Value A 10 B 12 C 15 D 20 Calc Total Items A A B A A C C C In Total I want to have the a formula that sums the value of the ...
1
vote
1answer
28 views

Extracting text between two repeated sets of values in Excel

I have campaign names that conform to the following structure: [Network] - [Language] - [Country] - [Channel] - [Campaign Type] - [Free Text] This could look like: Google - English - India - Display -...
1
vote
0answers
38 views

How to edit Google Spreadsheets file directly in Google Chat window?

How can I edit sheets directly in chat window as shown in this commercial video?
0
votes
2answers
66 views

How do I sum the nth number from the right in all cells

I am using a spreadsheet to collect all my questions and answers for a quiz I am doing. In the answers column, every answer is ended with [#p], # representing the numbers 1–9, never exceeding 9. ...
0
votes
0answers
17 views

How to reference “This” Column?

Maybe I'm dumb, but how do you just reference "This" or "Current" column? For example, counting entries in a column. I know you can enter a formula & drag it, or copy it & ...
1
vote
0answers
14 views

How to show different type of legend below specific columns under X axis on stacked bar chart

I have drawn a stacked column chart in Google sheet. I want to put different legends below specific columns as secondary label under the x-axis; here is my spradesheet link: https://docs.google.com/...
0
votes
0answers
14 views

How to return the sheet name of a given cell of a query result

I have scrubbed the internet for answer to this and and either I am asking the question the wrong way or it isn't possible. Here is a example template of what I am wondering about: https://docs.google....
0
votes
1answer
45 views

Merge two seperate columns in Google Sheets into a single column [duplicate]

I have a list that contains people's names in one column and their company's names in a second column. At the top of each column there is a label, i.e "Name" for column A, "Company"...
0
votes
1answer
68 views

How can you show the first cell in a cluster in Excel? And how can you lookup the value?

Several questions. But let me break down the problem of what I am trying to do: I have a condition to show YES/NO if a certain value is met. If YES >= 60 and NO <=30 - this is easy I can do ...
0
votes
0answers
29 views

Excel sheet to read data in real time from *shared* spreadsheet

I have an online quiz setup using Google Sheets, and I want to transfer it to Excel. Here's what I have: Team1,...,Team9 have their own 'Answer Sheets' which are Sheets with a cell, A2, where they ...
0
votes
0answers
28 views

Convert automatic values into raw data in Spreadsheets

I receive data automatically from a website into a Google Spreadsheet. So each new entry gets a new row. Within that spreadsheet I added a new tab to re-layout the data "nicely". I do that ...
0
votes
0answers
11 views

Google Sheet “View only” - add my own comments (for my own viewing only)?

I have access to a Google Sheet that's "View only" (so I can't edit or comment). I was wondering though if I could nonetheless add my own comments and other annotations for myself? (So for ...
1
vote
2answers
58 views

Is it possible to reuse the same sumif range?

In the following table, I constantly reevaluate a2:a4 to run different calculations against it. In a real table it would have been thousands of rows like it. Is there a way to somehow store a2:a4 in a ...
0
votes
0answers
19 views

How to average different % values depending on drop down list text value

I am trying to have a function that takes the %'s of a column and average them only if the text value of another column on the same row is a certain text value, over multiple rows in sheets I tried ...
0
votes
1answer
31 views

How to highlight down columns for many columns at once that are separated in an excel sheet?

I have 30 columns of data with over 10,000 rows. I'm using Ctrl+Click to highlight specific cells and then use Ctrl+Shift+Down arrow to highlight to the bottom, but I noticed it won't let me do that ...
0
votes
0answers
27 views

Original Google Sheet recognized by JS. Copy not recognized

I have a working Google Sheet JSON search engine here: https://codepen.io/Teeke/pen/gOwgvXQ?editors=0011 It reads this Google sheet: https://docs.google.com/spreadsheets/d/1c2aJmDdLkbjW0ErfUB0sfiQ-...
0
votes
3answers
53 views

Sum of vlookups for each value in a row

There should be a way to do this, and yet I'm struggling... ==The Data== Sheet1 A B +---------------+-------+ | Fishy_Product | Price | +---------------+-------+ | Cod | $9....
1
vote
1answer
51 views

Microsoft Excel/Google Sheets - Update Adherence

I would like to produce a result wherein it checks if an update is done within 3 hours, it would be pass. If it goes beyond 3 hours, then it would be a fail. So this is how my raw data looks like: ...
0
votes
1answer
71 views

Too Many Arguments when using IF google sheet

I want to implement this formula in Google sheet and I'm getting the error for too many ifs. Any help? =IF(I2="win",SUM(J2*G2),IF(I2="loss",SUM(J2*-1),IF(I2="push",J2),IF(...
0
votes
1answer
30 views

Can I make a graph for iterative function in MS Excel or Google Spreadsheets?

Let's say I have a formula: k = 0.2 a = pow(a, k) I'd like to see how the curve changes on each iteration with a different k value. The formula can be anything. The only thing is - I need the ...
1
vote
0answers
15 views

How to prevent duplicate URLs in google sheet? [closed]

Is it possible to prevent duplicate URLs in google sheet like the following: User enters URL: https://superuser.com/questions/ in a row of column C. If user wants to enter any subdomain or other URLs ...
0
votes
1answer
886 views

google sheet formula, if “yes”, copy to other sheet

I’m trying to figure out the formula in google sheets - if the cell is “yes”, then copy the adjacent cell to another sheet. Can anyone help?
0
votes
1answer
87 views

What is the processed called when converting data in repeated columns to rows on a spreadsheet?

If I have a spreadsheet with a data structure where similar information is repeated across multiple columns like so: TxID Date Merchant Item 1 Name Item 1 Value Item 2 Name Item 2 ...
0
votes
2answers
75 views

Return text string for highest duplicate values

I've been battling with a google sheets conundrum so hoping someone can help. In a nutshell, I'm trying to achieve the following based on the image below: Where the name is the same in column C ...
1
vote
0answers
19 views

In Excel/Google Sheets, how can I get the rows between two strings/headings which are in the first column?

I have a sheet which is formatted like this: original_sheet Header1 Row 1 Row 2 Row 3 Row 4 Header2 Row 6 Row 7 Row 8 Header3 Row Row Row I am looking to copy the rows under each header into their ...
0
votes
1answer
137 views

Excel/Sheets - Adding the content of a row to the end of another?

So I'm still new-ish to data analysis on Excel and/or Sheets, and I'm trying to "merge" data. Essentially, I have a few thousands rows, and I want every second row to be added to the first. ...
0
votes
2answers
74 views

How do i search and replace the entire cell content by a string in excel?

I have some cases to replace the following string with another string TES1 if the string has _M1 in it. Where ever _M1 is there I have to replace the whole cell content with TES1. similarly, I need to ...
0
votes
0answers
43 views

Fill down every (x) rows for (x) rows inserting as new rows instead of overwriting what's below in spreadsheet (WPS Office)

I have an existing CSV which contains shipping rates for every country in the world. I need to extend the rates for each country. Each country currently occupies 80 rows each. Every 80th row (the last ...

1
2 3 4 5
8