4

Change your * to a +, so you end up with ">([^<]+)<. I don't think you want the double quotes at the end either, since Account is followed by </div>, not by something like <"div which wouldn't be valid HTML anyway. * means 0 or more matches, + means 1 or more. See e.g. Wikipedia for some information about these 'quantifiers'. Here ...


2

You can use the following formula =CONCATENATE(SORTN(ArrayFormula(IFERROR({REGEXEXTRACT($A$2:A,".*NB"), REGEXEXTRACT($A$2:A,"NB(.*)")*1})), 1,2,2,0)) Functions used: CONCATENATE SORTN ArrayFormula IFERROR REGEXEXTRACT


2

Edit. You can use Index & Match to get the reference to the max item in the array and return the matching item from C. I don't like this approach as your declaring an array twice so the computation is more expensive, I would suggest the answer by @marikamitsos =INDEX(C2:C9,MATCH(MAX( ARRAYFORMULA(INT(IFERROR(REGEXEXTRACT(C2:C9,"NB(\d+)"),...


2

Please try the following formula in Custom formula is =IFERROR(IF(MATCH("*"&INDIRECT("H5")&"*",B2,0)>0,true,),false)


2

You can try the following =ArrayFormula(REGEXREPLACE($Q26:Q,"\w+","1")) (Please adjust ranges to your needs)


2

@Riley, using SUBSTITUTE, you "wrap" like this: =ArrayFormula(SUBSTITUTE(SUBSTITUTE(C:C,"wd","Web Development"),"ch","Chores")) It's a bit like those Russian nesting dolls.


1

Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), “Select #(Col2) where Y N(Col1) contains ‘Y’ “) one problem is that it's using typographical quotes instead of straight quotes. As second problem is that the second argument syntax is wrong. Regarding =QUERY(IMPORTRANGE("SheetA","F!O:P"), "Select * Where Col2=<&...


1

The problem in =IF(INDIRECT('Form Responses 3'!G$20)="","",COUNTIF('Form Responses 3'G$1:G$167,F20)) is that INDIRECT requires a text value but you are passing a reference. To fix it enclose 'Form Responses 3'!G$20 between ". Resulting formula: =IF(INDIRECT("'Form Responses 3'!G$20")="","",COUNTIF('Form ...


1

The following formula do the job =ArrayFormula(SUM(VALUE(REGEXEXTRACT(E2:E3,"\d{1,}")))) REGEXTRACT use regular expressions to extract text and works fine together with VALUE and ARRAYFORMULA \d{1,} is a regular expression that match any digit (0-9) following by any number of digits.


1

@Steven, I've added a sheet ("Erik Help") with the following custom CF formula/rule applied to D4:D73 ... =NOT(ISERROR(VLOOKUP("*"&D4&"*",{C$116:C$125;E$116:E$125},1,FALSE))) NOTES: NOT(ISERROR(VLOOKUP(...))) basically means that something was found (i.e., if it's not an error when Sheets tries to find it, then it was ...


1

Set the data validation for A1 as follow: On Cell range set the cell range from Column A. On the Criteria dropdown select: Custom formula is On the formula input box add this formula: =OR(B1=0,A1<=B1) On the On invalid data radio buttons selet Reject input Dont' forget to click Save


1

Solution: Use that in cell C1: =TEXTJOIN(,,A1,B1) Output: References: TEXTJOIN


1

How to Add Text to Beginning or End of Cells without a formula Please follow these steps Step 1 Go to the top menu --> Edit --> Find and replace Step 2 From Search choose Specific range and clicking on the little icon pick your range. Step 3 Check the Search using regular expressions and un-check Match case Step 4 To add text in the end, on the ...


1

You mentioned ...select the dishes in a single cell in this manner: ...just dump them into the column A, dishes search section in Search for Dish tab ...query should grab the relevant dishes from the Inventory tab, omitting the numbers before the dish name Place the following in cell B3 in your NEW Search for Dish tab. =IFERROR(TRANSPOSE( ...


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