Hot answers tagged

2

Unfortunately, no. The only ingredients for a normal Facebook status update are "UpdatedAt", "Message", and "From". A link status update does offer a "Link" ingredient, but that's the URL of the link you're posting, not the link to your status message.


2

Use arrayformula to perform operations on arrays, for example =sparkline(arrayformula(B2:E2 - A2:D2)) plots the sparkline of differences B2-A2,..., E2-D2.


2

May be an old question but its still being looked up - so here is the workaround: Importrange as we all know will only import raw un formatted data into a new googlesheet. As a workaround to avoid the hassle of redoing all the conditional formatting rules on the new import data sheet, do the following: - on the original sheet which you plan to import data ...


2

The docs say the list has to be "sorted" Yes, this is the problem. lookup expects the range to be searched to contain a list that is sorted alphabetically (if it contains text strings) or by value (if it contains numbers). If this expectation fails, it will not tell you anything but will likely return a wrong result. So you have two options. (bad) ...


1

One can get the last date of a list by sorting it in descending order and applying array_constrain. For example (not using your data structure) =array_constrain(sort(filter(B:E, C:C < today()), 2, false), 1, 4) means: among the rows where the date in column C is prior to today, select one with the latest date in C. The sort happens by the 2nd column ...


1

It can't be done using the Google Drive search feature but it can be scripted using the Google Sheets API. First you need to retrieve the list of spreadsheets that you have access to. Next, you loop over those worksheet IDs and perform a search within the rows, looking for the "$1000" value or anything else you want to find. If there is a matching row then ...


1

Here's my simple way of going to the last row in a Google Sheet: Insert "xxx" or any other unique string of characters in the last rown of your spreadsheet (leave some empty rows above where you put the xxx). Type "CTRL F" to start up the Find dialogue box. Type "xxx" and hit Enter. Bingo you're in the last row of the spreadsheet. As you fill in the last ...


1

You can do you your match with the simple VLOOKUP formula if data is within different sheets on the same spreadsheet, but the example from codingbadger is missing an argument (has to have "FALSE" for the formula to only deliver exact matches, it won't work if different or missing). Sample Usage: VLOOKUP(10003, A2:B26, 2, FALSE) Syntax: VLOOKUP(...



Only top voted, non community-wiki answers of a minimum length are eligible