google-sheetsfiltergs-vlookupgoogle-sheets-formula
If there are equal links in column 3 but one of them in Column 2 is written PSTP, none should appear on list
I have a big formula in my spreadsheet that imports data from internet pages, in the first column it imports the date, the second column the hour to kick off of the game and the third column the link to the match.
Some matches are canceled, causing column 2 where the times would appear, now "PSTP" will appear, as it is updated daily, in the records there may be a link with time but as the new one is appearing "PSTP", in this case I would like that neither the old nor the new appear in the list.
Current format:
Expected result:
I leave here the link to the spreadsheet so that it can be analyzed together with the existing formula because I will not publish it because it is too big:
https://docs.google.com/spreadsheets/d/1UyRqZPbZasqz6yIDSWTVCR_AuEm-cfoj8RHWfJ8Owio/edit?usp=sharing
Solution
try:
=ARRAYFORMULA(FILTER(A1:C, REGEXMATCH(VLOOKUP(A1:A&C1:C,
SORT({A1:A&C1:C, B1:B}, 1, 1, 2, 1), 2, 0), "FT|PSTP")))
or directly:
=ARRAYFORMULA(FILTER({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
}, REGEXMATCH(VLOOKUP(INDEX({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
},,1)&INDEX({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
},,3),
SORT({INDEX({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
},,1)&INDEX({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
},,3), INDEX({
IFERROR(FILTER(Sheet2!A2:C,Sheet2!A2:A<>""),{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E2,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E2,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E2,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E2,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E2,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E2,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E3,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E3,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E3,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E3,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E3,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E3,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E4,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E4,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E4,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E4,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E4,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E4,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E5,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E5,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E5,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E5,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E5,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E5,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
;
IFERROR(
{
TEXT(IMPORTXML(E6,"//tr[@class='no-date-repetition-new' and ..//td[@class='score-time']]"),"yyyy/mm/dd"),
IF(IMPORTXML(E6,"//td[@class='score-time']")="PSTP","PSTP",TEXT(SUBSTITUTE(IMPORTXML(E6,"//div[@class='match-card match-hour']")," ",""),"hh:mm")),
IFERROR("https://int.soccerway.com"&LEFT(IMPORTXML(E6,"//td[@class='score-time']/a/@href"),FIND("?ICID=",IMPORTXML(E6,"//td[@class='score-time']/a/@href"))-1),"https://int.soccerway.com"&IMPORTXML(E6,"//td[@class='score-time']/a/@href"))
}
,{"","",""})
},,2)}, 1, 1, 2, 1), 2, 0), "FT|PSTP")))
- How to Select Specific Ranges in Results
- Generate unique random numbers in Google Sheets
- "Array arguments to COUNTIFS are of different size" - counting the number of rows in Sheets with multiple criteria
- Can an image be inserted inside a Donut Chart in Google Sheets?
- How to calculate running average with 1 formula in Google Sheets?
- How to get data by filtering YEAR using google sheet script
- Ranking formula in Google Spreadsheet
- Google sheets conditional formatting of lowest n
- Google Sheets Getting data from cells in 1 column using multiple instances of text entry's from a different column
- drive.permissions.create error - too many parameters
- Google Sheets IMPORTXML - Scrape Exhibitor List
- How do I fix this script in Google Apps Script to create a button regarding Date Range?
- How to Add Headers or Categories When Selecting Specific Ranges in Results
- Google Sheets Transpose Formula
- Separate Data in One Column into Multiple Colums
- Get first non-empty cell in row
- How to conditionally change a date based on a time? Time zone differences?
- How to know Sheet ID that using BigQuery Sheet Connector
- Getting the data from the new Google-sheet tab with INDIRECT
- Google Sheets. How to create formula to get 10 highest values from one table and put to another one?
- Use Lambda to stack multiple query array
- Using EOMONTH in Google Sheets considering time not just date
- Conditional Dropdowns in Google Sheets Based on Multiple Criteria
- Conditional formatting if cell past date and another cell empty with arrayformula
- ranking formula start from negative number
- Trouble getting log function to work in a custom function for Google sheets
- Checking for an option in a multi-select dropdown
- ARRAYFORMULA SUM
- Display pasted cells temporarily then return to main page
- How can I search a Google Sheet for the cell that matches the intersection of the first column and top row of another sheet