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
0 votes
0 answers
9 views

Google Sheet Random Text with HS Code [migrated]

Is there a way I can put any text, for example: (XXX Shoes/Dress/Shirt), then it will output a HS code corresponding or even a general HS code on another cell in the Google Sheet?
user avatar
  • 1
0 votes
1 answer
15 views

Get the count or sum of count of each individual items used in multi-select dropdown in google sheets

I have created a multi-select drop-down of items a,b,c, & d. Let's say I enter a,b in C1 and a,b,c in C2 and a,b,c,d in C3. Now, I want to get the total count of each item I have selected. Here, ...
user avatar
0 votes
1 answer
23 views

Return X amount(s) of cell values under under specific cell address

To start, thanks for reading, I will be leaving this picture here, which is what my current sheet looks like. I'm trying to parse the information on A:A so that every instance of "X/Y", ...
user avatar
  • 1
0 votes
1 answer
27 views

How do I split text into columns, and then have separate columns for specific properties?

I have a column with text in the format below Properties admin_role=sales_other;;business_type=b2b;;categorisation_complete=yes;;company_reporting_segment_fy22=100+;;engage_usage=medium;;...
user avatar
0 votes
0 answers
27 views

Find one value and replace value inside quotes within the same row

I translated values for a JS calculator but the script that I am using treats the option value the same as a value inside a parenthesis. Currently have it on notepad ++ but can migrate to anything ...
user avatar
0 votes
0 answers
8 views

Googlefinance function - What ticker symbol to use for the crude oil price? [migrated]

Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function? Nasdaq Brent oil is "BZ:NMX" https://www.nasdaq.com/market-activity/commodities/bz:nmx Nasdaq Crude oil ...
user avatar
0 votes
0 answers
8 views

Is it possible for spreadsheets to fix a value after calculation even if references change afterwards? [migrated]

What I want to do is that a cell gets calculated and it never gets calculated again, or a workaround. My use case is this. I have a google spreadsheet where I have two percentages, those percentages ...
user avatar
  • 331
0 votes
1 answer
8 views

How to delete blank cells and regroup not empty cells on Google Sheets column

You have a column, some cells have data, some are empty. How can you regroup the not empty data? example, you have this: this is an example +++++++++++++++++++++++++++++++++++++++++++++ and you want ...
user avatar
  • 1
0 votes
5 answers
40 views

How to keep a spreadsheet cell reference fixed when rows are inserted?

Say I have a Google Sheets or Microsoft Excel spreadsheet where the formula in cell A1 is "=SUM($A$5:$A$100)". Assume there is data is cells A5 through A10, but nothing (yet) in A11 through ...
user avatar
  • 4,088
0 votes
3 answers
47 views

LOOKUP Column Value based on right-most value

I have a list of footage for a film that is continually changing. They are organized in rows by REELS, and the rightmost value will be the latest version. The first row are dates and the rest are ...
user avatar
1 vote
0 answers
36 views

Google Spreadsheets: Find last unique value in column given some conditions [closed]

I have an excel like the attached below. I want to find the last unique value (transaction) of column A, given that column I is > 0. Any tip how to achieve this?
user avatar
  • 111
0 votes
1 answer
64 views

Can we add tags in any spreadsheet software like we can in Notion?

I’m working on long tables (like a database or repository, no mathematical function) and I need to refer a few cells in another sheet And also use some tags for each row. I know in Notion, you can ...
user avatar
  • 145
0 votes
1 answer
33 views

Maintaining "date" format when importing from Google sheet Excel

I have a dataset that I imported from Google sheets where all values in the "date" column were formatted as DD-MM-YYYY. However, once the data are imported into Excel, some values maintain ...
user avatar
0 votes
1 answer
23 views

Excel/GoogleSheets Forumla to List All Rows Without A Corresponding Value in Another Column

I'm hoping there is a simple way to perform the following. I have 2 columns (A,B), and I would like a third column (C) which consists of all values from column A that have an empty cell in column B. I ...
user avatar
0 votes
1 answer
21 views

Split cell then Vloop then sum

I have a google form linked to a google sheet. There is one multiple choice checkbox question in the form that asks the user to check A, B, C. In the google sheet, the answer are concatenated with a ...
user avatar
  • 183
0 votes
1 answer
18 views

Excel countifs ignore one specific column

=if(COUNTIFS('Finishing Results'!G5:N5,'Finishing Results'!P5:AC5,"1")=0,COUNTIFS('Finishing Results'!G5:N5,'Finishing Results'!P5:AC5,"1")) Trying to exclude ('Finishing Results'!...
user avatar
0 votes
1 answer
19 views

How do I syntax a simple logarithm in a spreadsheet formula?

simple logarithm How do I syntax this question in a spreadsheet formula? Trying to find N. (see image on at top) Don't know how to write the formula for this, or what function to use. s = 4 e = 2000 ...
user avatar
0 votes
1 answer
19 views

Google Sheets/Microsoft Excel Numeric Row - Sort By Number

I have a row that contains the following numbers: 26 29 37 28 25 41 46 42 39 37 30 25 51 49 57 53 33 28 45 50 I used the following function to sort this: =SORT(A6:V6) But it did'...
user avatar
0 votes
4 answers
154 views

Excel: How to convert a column letter to the corresponding column number without using COLUMN() and INDIRECT()?

The standard solution seems to be =COLUMN(INDIRECT(letter&"1")) but there should be a better solution that avoids the volatile INDIRECT function. Sample Column Letter Corresponding ...
user avatar
  • 101
0 votes
3 answers
37 views

Google Sheet / Microsoft Excel

Seeking out on your help expertise as I'm checking if there's a way or a function or formula so that the dates under Column C will reflect will reflect on each cells in Column S. Here's the file: ...
user avatar
  • 1
0 votes
1 answer
64 views

Formula to identify a list of codes in various combinations

Bit of a tough one to explain, but here we go... I have a large database (15K rows) of unique codes (AA1, AA2, AB1, etc.) in letter & numbers convention that identify them to a specific name (in ...
user avatar
0 votes
0 answers
66 views

Excel formula to calculate percentage based on 2 different ranges

I'm trying to calculate the percentage 2 two ranges, in other words, the "Win Rate" based on the B column input and E column input. As you can see in the image attached, we have column B ...
user avatar
  • 1
0 votes
1 answer
68 views

Create new lines after comma in spreadsheet?

I have 2 sheets on google sheets/excel, I'm attempting to create a new line after each comma (if one is present), so it's easier to see. I've tried using regexreplace and substitute but I just can't ...
user avatar
0 votes
1 answer
16 views

How to return cell value if no dot exist instead of return "#VALUE" in Google Sheet / Excel?

This formula do the job, but I do not want it to return #VALUE!, instead of the name if no dot exist end of string. Also "Dr. Mrs Zainab Adams." -> "Dr Mrs Zainab Adams." I ...
user avatar
0 votes
0 answers
89 views

Override font smoothing (antialiasing) method in Google Sheets grid (Firefox)

How to override font smoothing used in Google Sheets grid to make fonts sharp (as everywhere else on a page)? As you can see from the screenshot below, most of the elements use sharp font (standard ...
user avatar
  • 251
0 votes
1 answer
62 views

Count cells in a column between values until specific value reached in Google Sheets - Multiple Criteria

I am trying to do a tricky conditional count on a dataset. I need to count the number of rows that meet a set of criteria (after a specific date, a certain category) that sums up to a set limit - that ...
user avatar
-1 votes
2 answers
74 views

How to easily manage unique values for a column in Excel/Google sheets?

This feature is very common in web application but I could not find a similar solution in Excel. I manually enter metadata for different publication. One column is the publisher. I want to have a drop ...
user avatar
0 votes
0 answers
25 views

Spreadsheet list referencing another spreadsheet

I am creating a medication calendar. I have a list of medications in one column. I have a column titled 7am and then the contents of the column are how many pills I take at that time. In a separate ...
user avatar
  • 1
0 votes
2 answers
64 views

Perform multiple calculations in one cell

I have a spreadsheet that has 4 columns that perform a simple "if" based on some data entered elsewhere. Adjacent to each of those columns is another column that assigns a "1" or &...
user avatar
0 votes
1 answer
77 views

I need to arrange cells in excel leaderboard in a way that would show on what place each team was on each stage [closed]

Picture shows a desired outcome typed in manually. Cells need to be automatically arranged in a way that would show on what place each team was on each stage of a competition with their points, ...
user avatar
  • 171
0 votes
1 answer
23 views

In Excel I am wondering how if a value is met in a column then to sum up the cell to the left of that value across multiple rows if that makes sense

For example where the cell says David I want to sum all the cells on the left of David in £ up to a total like at the bottom not sure how I'd go about this. £4500 IWI 14/12 DAVID ...
user avatar
  • 1
0 votes
2 answers
60 views

Extracting multiple values from a sentence in single cell with same preceding value. eg. Player 1, Player 2

Im trying to extract just the Player numbers from the sheet below. What is the best way to extract just "Player + (player number)" ?
user avatar
0 votes
0 answers
90 views

How to prevent updating a cell reference in Google Sheets when new columns are added?

In my Google Sheets spreadsheet, I have sheet A ("Summary") with a few cells that reference other cells in sheet B ("Raw data"): Sheet B contains raw data that is added via API: ...
user avatar
1 vote
2 answers
41 views

How would I go about adding up all the raw ingredients sold per items with different proportions?

I haven't used Excel/Sheets for a while and I'm pretty rusty at the moment, even though I think there's a simply solution to this. I have a table with a column that has every item on the menu and rows ...
user avatar
0 votes
1 answer
24 views

Count just columns consecutive in sheets

I am trying to add or count only the values ​​that are consecutive between the columns, that is, I want to be able to identify by name when the condition that there is six times the number one is met, ...
user avatar
  • 1
0 votes
1 answer
30 views

Count rows matching 'x' in column A OR column B, while ALSO matching 'y' in column C

Sample Data: A B C 1 Jene Alex 2 Sasha Jene X 3 Alex Sasha X 4 Alex Jene 5 Alex Sasha X I want my count to include all rows that have the name in either column A or column ...
user avatar
  • 249
0 votes
1 answer
40 views

How to add a comma and the word "and", "then" ,"or", and so on to a list in Excel or Google Sheet

=SUBSTITUTE(TEXTJOIN(", ",TRUE,$G3,$I3,$K3),", "," and ",MAX(1,COUNTA($G3,$I3,$K3)-1)) Right now the return is: G3, I3 and K3 (the last comma before "and" is ...
user avatar
  • 1
0 votes
1 answer
24 views

Need help in Excel Adding 2 columns

i just want to add column 2 to column 1 if and only if column 2 has just 1 text character in its cell .enter image description here
user avatar
0 votes
1 answer
312 views

Update reference in Google Sheets formula when a form adds new rows

Using help from various sources and bits of a formula taking data from different Google Sheets columns, I now have the following formula for calculating some numerical totals. I cant get it to update ...
user avatar
1 vote
0 answers
33 views

Copy + Paste a cell, keeping the cell reference the same but increasing the column increment by one

I'm working on a dashboard (Google Sheets) at work, which shows all the figures for 12 different sites. The sites are arranged in rows with columns used for different figures (revenue, bar sales, ...
user avatar
0 votes
0 answers
18 views

Transfer Locking & Protection from Excel to Google Sheets

A few questions: Is there a way to transfer the sheet locking and protection (and the cell locking) to Sheets? Is it possible to lock cells in Sheets, as in Excel? And I am specifically referring to ...
user avatar
  • 117
0 votes
0 answers
8 views

How can I make the range in COUNTIF formula change by dragging (if the ranges are multiple consequent Named Ranges)

I have the following named ranges: AgentW1 AgentW2 AgentW3 ... AgentW13 and the following formula: =COUNTIF(AgentW1 , $A10) I need this formula 12 more times with the following syntax: =COUNTIF(...
user avatar
  • 1
0 votes
0 answers
26 views

Excel/Google Sheets - Generate notecards/flashcards from table

If I have a spreadsheet (or a CSV file), how might I render out pages to print (preferably notecard size) from a table, without being a laborious, manual process? There are some guides online, for ...
user avatar
0 votes
1 answer
23 views

How to FIlter/Match spreadsheet data based on two row headers?

I need to find a value based on a specific column and header, that also fall within another merged header (spans 3 cells) like the example below: |January 2020 |February 2020 |...
user avatar
  • 239
0 votes
0 answers
36 views

How to VLOOKUP based on two column criteria?

I'm not exactly sure if this calls for a vlookup, but it's the closest I could think of to solve the following scenario: Animal|Color|Total ------------------ Cat |Red |150 Cat |Blue |85 Cat |...
user avatar
  • 239
0 votes
1 answer
38 views

How can you format each row from a pivot table to display transposed with the headers repeating themselves?

From a pivot table, I am attempting to take each row of data and format it transposed with the headers from the pivot table present in each instance. Here is a link to a Google Sheet that has a sample ...
user avatar
0 votes
0 answers
18 views

Google Spreadsheet published as CSV sometimes returns #VALUE

I'm publishing as a CSV a spreadsheet I'm maintaining in Google Sheets, to serve as a data source for other people/systems. It's a simple 4-column data structure, resulting from a complicated ...
user avatar
  • 831
0 votes
0 answers
46 views

Reading a section of data from one sheet and applying conditional formatting to equivalent entries on another sheet

I have a one sheet of data sorted by date, where A2:X45 are one year, then below A47:X92 are the next year, etc. Months are by column from A3:X3. A2 and A46 are where the year is labeled. A1 is a ...
user avatar
0 votes
1 answer
44 views

How to select some data labels to be shown in Scatter Plot Chart (Google Data Studio)

I've a massive amount of rows, therefore I have lots and lots of data labels: Huge amount of labels in Scatter Plot How select some points to show labels and hide others? (Or if it's not possible, is ...
user avatar
  • 1
0 votes
0 answers
44 views

How to bring sum of previous column in to next column automatically, in Excel or Google Sheets?

I'm new to this. I'm trying to make a personal budget sheet, where I can bring the previous months' sum into the next month's column as "savings from last month". Basically I want to show ...
user avatar
  • 145

1
2 3 4 5
9