Technical Forum to Ask, Learn, & Collaborate

0 votes

1 answer

DevOps: Epics and Features not showing up in Plan

Work items and dependency lines must appear ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
• 220 points • 2,653 views

0 votes

1 answer

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 86,360 points • 1,310 views

0 votes

1 answer

Formula to count if a text is written in a cell

Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 86,360 points • 1,263 views

0 votes

1 answer

Unprotect an Excel file programmatically

Try this. It worked for me. def Remove_password_xlsx(filename, ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 86,360 points • 3,641 views

0 votes

0 answers

i actually created a bean in spring context,when i get that bean there is an error msg NoSuchBeansDefinationException

package com.learningSpring.learningSpring; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @Configuration public class HelloWorldConfiguration { ...READ MORE

Feb 21, 2023 in Java by anonymous

edited Mar 5, 2025 • 547 views

0 votes

1 answer

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 86,360 points • 1,478 views

0 votes

0 answers

Determining whether an value is a whole number in Python

I would like to determine if a ...READ MORE

Feb 22, 2023 in Python by Arya
• 990 points
edited Mar 5, 2025 • 483 views

0 votes

1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

Nov 8, 2022 in Others by narikkadan
• 86,360 points • 5,049 views

0 votes

1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 86,360 points • 1,289 views

0 votes

1 answer

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 86,360 points • 1,244 views

0 votes

1 answer

white screen on simulator iphone Xcode

After creating the request, you must actually ...READ MORE

Sep 20, 2022 in Others by Aditya
• 7,680 points • 7,160 views

0 votes

1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

Try this: Option Explicit Sub CopyChartsToPowerPoint() ...READ MORE

Jan 23, 2023 in Others by narikkadan
• 86,360 points • 1,756 views

0 votes

1 answer

Divide a range of values for each unique value

With the next available row as the ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 86,360 points • 1,322 views

0 votes

0 answers

Get target group arn from aws cli

I'm attempting to obtain the arn of a target group whose name contains the word "test" or the value assigned to "value," but I'm having trouble because I keep getting this problem. value=test aws elbv2 describe-target-groups --query "TargetGroups[?starts_with(TargetGroupName, '${value}') == ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points • 1,735 views

0 votes

0 answers

Passing azure secret variables to pytest in pipeline?

We are using Azure Pipeline to run Python integration tests. These tests make use of a database, and the login information is saved in an Azure variable group that also contains secret variables. The integration tests are started in this section of the yaml file: jobs: - job: IntegrationTests variables: ...READ MORE