Month November 2022

[Solved] Comparing comma separated numbers in cells

In Excel 2016 (but NOT Excel 2013), you can use the following array-entered formula. =TEXTJOIN(“,”,TRUE,IFERROR(1/(1/(ISNUMBER(FIND(“,”&TRIM(MID(SUBSTITUTE(B2,”,”,REPT(” “,99)),seq_99,99))&”,”,”,”&A2&”,”))))*TRIM(MID(SUBSTITUTE(B2,”,”,REPT(” “,99)),seq_99,99)),””)) seq_99 is a Named Formula Refers to: =IF(ROW(INDEX($1:$65535,1,1):INDEX($1:$65535,255,1))=1,1,(ROW(INDEX($1:$65535,1,1):INDEX($1:$65535,255,1))-1)*99) To enter an array formula, after entering the formula in the cell, confirm by holding…

[Solved] Is a date within some of periods [closed]

This function should do what you want. It relies on MySQL treating boolean results as either 1 or 0 in a numeric context, thus the MAX call effectively becomes an OR of all the conditions. CREATE FUNCTION check_activity(project_id INT, check_date…

[Solved] Chips and Salsa using header file

There are many issues with your code. The following code may do what you want. You should study it and try to improve it. One such improvement could be the use of std::vector as opposed to arrays. This will mean…

[Solved] How to add 0’s to a floating point number?

Float doesn’t support precision configuration, only rounding and formating. You should use decimal instead: >>> from decimal import * >>> getcontext().prec = 2 >>> Decimal(1) / Decimal(7) Decimal(‘0.14′) Python decimal: 2 solved How to add 0’s to a floating…