# Tag Info

3

Instead of date 'TODAY()' use date '"&TEXT(TODAY(), "yyyy-mm-dd")&"'" NOTES: The last " should be placed in a proper place in order to have a text value as the second argument of QUERY. 'TODAY()' doesn't returns Today's date, it returns a string with the word TODAY followed by parenthesis. Try this =ARRAYFORMULA(QUERY({A3:H, HOUR(A3:A)}, "...

3

With a regex, you can replace each character with itself + ','. Then use a regular split function. =split(REGEXREPLACE(A1,"(.)","\$0,"),",",true,true)

2

This does seem very identical to an older question/answer. In fact, so close that you can get the two by just taking my previous solution and breaking it apart. =ARRAY_CONSTRAIN( SORT(ArrayFormula({TRANSPOSE(F1:1),ABS(TRANSPOSE(F1:1)-B7)}),2,1),1,1) to find the value. =MATCH(B8,A1:1,0) to find its column "number" where A = 1 I have entered the formula in ...

2

Use VLOOKUP(). Assuming your lookup table is in H1:I50, you'd put the following in B1: =VLOOKUP(A1,H1:I150,2,FALSE)

2

There are multiple ways to do this : Query, Filter but I think SUMIF will suits the most : =SUMIF(arrayformula(regexmatch(A1:A10;C1));true;B1:B10) =SUM(FILTER(B1:B10;arrayformula(regexmatch(A1:A10;C1)))) =trim(REGEXREPLACE(CONCATENATE(QUERY(A1:B10;"SELECT sum(B) where A = '"&C1&"'"));"sum";)) Spreadsheet : A | B | C ---------------...

2

If I remember my highschool days, your expression reads : Sum of the n from 1 to 30. I.E. 1000*1.07^1 + 1000*1.07^2 + 1000*1.07^3 + ... Here's a way to do it : =sum(ArrayFormula(1000*power(1.07,(ROW(A1:A30))))) Result is 101 073.04

2

You have the basic concept right just piece it together step by step. This does the job: =REGEXREPLACE(JOIN(" ",ARRAYFORMULA(IFERROR( REGEXEXTRACT(SPLIT(A1," ",TRUE,TRUE), "https://example.com/(\S+)"),""))),"\s+"," ") You split the string at whitespaces, this is safe because URLs don't contain white space so you're definitely not breaking them up. This ...

1

Logic: In first column we can put current date using =Today() this will give current date. In order to get next date we must increase the date by 1. To get next date we can add =Today()+1 If you want more sequential dates. Then follow this approach: Step 1. Column A put the cell A1 as =Today() Step 2. In column B we want number of days to add so make ...

1

=ArrayFormula({"Result";IF(A2:A="","",COUNTIFS(ROW(A2:A),"<="&ROW(A2:A),A2:A,"<=5"))})

1

Try ROUNDUP Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.

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