Top new questions this week:
|
As a sequel to this question Formula for matrix (dates in ascending order) how would the formula (=IF($B2="Apple",A2-SORT(FILTER(A:A,B:B="Pear", A:A<$A2),1,FALSE),"") ...
|
Firstly, apologies for this question but I couldn't really wrap my head on how to do this (ultimate aim is to put it in app scripts)
Let's say I have a table that is updated daily showing the fruit ...
|
In my spread sheet, there are 3 tabs, let's call them A,B and C.
Tab A has user input data
Tab B picks up that data (get.range and set.formula) and time stamps it (daily interval) with rows appended (...
|
Context
Here column C contains a running total of the last 5 items from column B.
Formula
The formula is straightforward:
Question
In the above, it's hardcoded for a running total of 5.
What's a ...
|
I would like my function freezeSunday to run at exactly at 1pm on Sunday. Since it does not appear that you can trigger a function to run at a precise time (only at a randomly selected time within a ...
|
I have two independent columns with data.
How could I use that data to then produce a flattened table like this:
|
I was wondering if there's a way to use a function (maybe Filter?) in order to sort this data such that column K only contains one of each number, and the highest test associated with it in column L. ...
|
Greatest hits from previous weeks:
|
What I'm looking for is a one click enable/disable or toggle in some form. The closest I've come is manually editing a cell to enter a 0 or 1, but I'm hoping there's a nicer pattern.
I know there's ...
|
I want to look at a Google cached version of a webpage, but can't find it through the usual mechanisms, as per this related question.
Is there a way to modify the URL in the address bar to take me to ...
|
The Google Translate application now supports in-image OCR and translation of text:
https://support.google.com/translate/answer/6142483?hl=en
but this functionality does not seem to be accessible ...
|
I have someone not added in my friends list that randomly visits my profile page. How can I know who visited my Facebook profile page besides the persons i’m already friends with?
I know that right ...
|
I logged into GitHub today and found something new I hadn't seen before:
What is this, and why did it begin to appear?
|
I have a Gmail account that I haven't used in ages so I've forgotten the login name I used to sign up with. I've forgotten the recovery e-mail address setup on the account but I can remember my ...
|
Is it possible to insert a datepicker in every cell of a column in Google Spreadsheet so that anyone can click (with a single click) on that cell and get a datepicker calendar to select a date?
|
Can you answer this question?
|
I'm trying to build a reservations spreadsheet for my friend's restaurant where she can input on monthly sheets as resos come in, then see a filtered, sorted summary of any selected day.
Here is a ...
|