questions/page/150
Yes, you can use the unmarshall method ...READ MORE
You can accomplish this with countif and a sliding ...READ MORE
--------------------------------------------------------------------------- ModuleNotFoundError ...READ MORE
Using the example from here. I can create ...READ MORE
dfd ffgfh zfggh zfxgfdgh zfgfgh zdfgh zdfgdfd ...READ MORE
Multiple ways, one is to use FILTERXML(): Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE
I'm attempting to employ the Azure DevOps ...READ MORE
I have an AWS WAFv2 Web ACL ...READ MORE
The below formula will create a unique ...READ MORE
You can use worksheet.freeze_panes() to achieve this . There ...READ MORE
Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE
I am working on a CICD pipeline ...READ MORE
Is a variable available for the name of an Azure devops pipeline task step, as highlighted below? image from the pipeline I went over the predefined variables at https://learn.microsoft.com/en-us/azure/devops/pipelines/build/variables?view=azure-devops&tabs=classic However, ...READ MORE
Go For Force Restart If it is a ...READ MORE
I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE
Heres a function. Can't remember where I ...READ MORE
Excel has a few oddities that must ...READ MORE
You can accomplish your goal with Power ...READ MORE
You appear to be misunderstanding the point: ...READ MORE
Dates in Excel are just formatted numbers, ...READ MORE
Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE
My career in the armed comes to ...READ MORE
Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE
same cell in excel from different worksheets ...READ MORE
I'm running a Python script in my ...READ MORE
I have a repo in Azure Devops ...READ MORE
Icons have their own coding you can ...READ MORE
In PQ, highlight the Group column and ...READ MORE
I come from the military communication field ...READ MORE
Try the following formula in C4 and ...READ MORE
Programmer in C and C++, currently attempting ...READ MORE
Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE
The copy inside the loop is overwriting ...READ MORE
Currently, I'm using az storage blob ...READ MORE
The data in xml file is someting ...READ MORE
I suppose Excel has handled December 21 ...READ MORE
i have called a function for owner ...READ MORE
Try this: =COUNTIF(B:B,"my citeria") so if your Column ...READ MORE
At the top of the script you ...READ MORE
Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE
Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE
First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE
I am having this error when I ...READ MORE
I'm trying to use the cameras LED ...READ MORE
Evaluate might suit: Function Eval(Ref As String) ...READ MORE
You must include the xlsx file extension. The ...READ MORE
Use the jQuery: selected selector in combination ...READ MORE
git pull < branch> <branch name > ctrl+x git ...READ MORE
If not already done, save and close ...READ MORE
Our build agent is running Podman 3.4.2, and each terminal session has a global alias that just replaces docker with podman, thus the command docker —version returns podman version 3.4.2 as a consequence. The purpose is to employ podman in an Azure DevOps pipeline for the Docker@2 task: steps: - task: Docker@2 displayName: Build and ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.