google-sheets-formula Questions
4
Suppose I have a long, unordered, and gradually growing column that I search the even numbers from.
=filter(A1:A,ISEVEN(A1:A)=TRUE)
Now I would like to reverse this result, so that the last even n...
Gumshoe asked 30/7, 2020 at 18:50
6
Solved
In Google Sheets, how do I get the value of the first non-empty cell in the row 17 starting at column C forwards?
Withhold asked 9/5, 2020 at 2:11
4
I’m stuck trying to create a Google Sheets formula that searches a range for a value, and when the value is found returns the value of column a on the row where the value is found.
Ie: my range is ...
Yarmouth asked 16/9, 2023 at 9:23
2
Solved
In Google Sheets, using formulae, is there a way I can search for a certain string in a certain sheet, and return the reference of the cell which contains that string?
The string would be unique to...
Drome asked 5/9, 2020 at 9:59
5
Solved
Simplified scenario:
Sheet Customer_Orders, has blocks of rows with each row having product code, count ordered, and size. Bunch of other stuff is looked up/calculated on the basis of these three ...
Carpel asked 11/11, 2019 at 20:54
5
Solved
I have (what I thought was) a simple lookup table holding some exchange rates. There I am looking up values based on row and column indices.
How can I do that in an ARRAYFORMULA like this?:
=ARRA...
Gatha asked 7/1, 2017 at 22:7
7
Because google spreadsheets does not support iterations, I wrote my own simple app script to adjust an input based upon the calculation of the spreadsheet output. However, after I change the input ...
Alfeus asked 3/10, 2012 at 14:51
8
I would like to display easily an image on Gsheet cell based from URL of image stored in Gdrive.
I have tried with the Gsheet function =IMAGE("URL") and it does not work.
The objective is to disp...
Novelize asked 18/2, 2020 at 18:42
4
Solved
I'm using Google App Script for the first time.
I'm using it on a Google Doc spreadsheet.
I'm trying very simple functions, just to learn the basics. For example this works:
function test_hello()...
Aesir asked 26/7, 2012 at 0:14
2
Is there a way to get the identification (i.e. A1 notation) of a selected cell or range in Google Sheets?
Something like:
=SELECTION(['Sheet1']) -> "D6"
Trihydric asked 11/6, 2015 at 11:23
7
Solved
I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR.
Here is my formulae: =Finance!B4*GOOGLEFINANCE("...
Zippel asked 15/11, 2017 at 14:59
4
Solved
I'm wondered if it's possible in google sheet to convert Gregorian calendar to jalali using a function. In fact, I have some date such as :
February 20, 2021 4:30 AM
I need to display this date in...
Straightforward asked 22/2, 2021 at 12:41
2
Solved
I've found a way to copy formulas only in Google Sheets through Search and Replace Ctrl + H feature workaround as follows:
STEP 1:
Cells with Formulas to be copied
STEP 2:
Press Ctrl + H and Tick ...
Pull asked 10/5, 2021 at 13:49
12
I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there.
I have a summary table with anywhere u...
Crean asked 25/7, 2014 at 11:27
4
I have been using chats.googleapis.com for creating qr codes.
But now it is not working.
=image("https://chart.googleapis.com/chart?chs=300x300&cht=qr&chl="&ENCODEURL(A2))
I ...
Africah asked 4/1 at 9:45
4
Solved
This should have been simple but I can't find a workaround. I want to split a string into its characters.
e.g. dog will be sepearted to:
d
o
g
The problem is I can't put an empty character as a del...
Draught asked 23/4, 2021 at 11:7
3
Anyone know workarounds to make GoogleFinance actually work?
It works for a while so it is not a problem with my formulas but then periodically the cells that were showing stock quotes suddenly sho...
Daguerre asked 22/1, 2020 at 5:53
7
Solved
In Google spreadsheets, I need a formula to extract all digits (0 to 9) contained into an arbitrary string, that might contain any possible character and put them into a single cell.
Examples (Inp...
Rotenone asked 19/1, 2017 at 21:36
4
Solved
I have this string in one single cell (A1):
Apple – 1
Banana – 6
Cherry – 10
Peach – 100
Apple – 1000
Kiwi – 10999
Peach – 44
Fig – 3/100
Fig – 3/100
I need to find a formula that can combine dupl...
Sensitize asked 28/2 at 0:2
2
Solved
The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument.
https://support.google.com/docs/answer/3093281?hl=en
However, the documen...
Bendwise asked 30/12, 2019 at 18:0
24
Solved
I use the following function
=DAYS360(A2, A35)
to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as...
Tridentine asked 14/11, 2011 at 0:34
25
Solved
I have a spreadsheet with some values in column G. Some cells are empty in between, and I need to get the last value from that column into another cell.
Something like:
=LAST(G2:G9999)
except t...
Wessex asked 12/11, 2010 at 23:21
3
Solved
I want to check if in a cell there is one word but not another. In this post there was some buzz around this matter but the elected solution included a script function. There has to be an easier wa...
Misguided asked 22/2, 2019 at 21:33
3
Solved
I have a column of data, and I need to find the previous non-blank cell. For example, if I have the following data:
foo
-
-
-
-
(formula)
where - denotes a blank cell, then I want the (formula) ...
Hurtle asked 1/10, 2015 at 14:49
2
Solved
I created a formula to sort positive values.
=SORT(FILTER(A2:A, A2:A>0),1,1)
And turnd it to a named function with this formula definition, and named it SORT_POSITIVE
=SORT(FILTER(range, range&...
Nadeau asked 26/9, 2022 at 8:11
1 Next >
© 2022 - 2024 — McMap. All rights reserved.