Trending questions in Edureka Community

0 votes
0 answers

Referencing an element while using count in terraform resource and handling the case when count is 0

I have an AWS WAFv2 Web ACL ...READ MORE

Dec 20, 2022 in AWS by Tejashwini
• 5,380 points
2,424 views
0 votes
0 answers

What is "main" branch in context of Azure DevOps pipeline caching?

I'm attempting to employ the Azure DevOps ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,808 views
0 votes
1 answer

how devops works with aws?

The two most potent technologies—AWS and DevOps—can ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Edureka
• 12,730 points
1,789 views
+1 vote
4 answers

How to get typed text from a textbox by using Selenium Webdriver?

Hey Ashmita, to get the typed text ...READ MORE

Jun 25, 2019 in Selenium by Abha
• 28,140 points
45,584 views
0 votes
0 answers

the cloud platform which are not used for devops implementation?

Among which if the following cloud providers ...READ MORE

Dec 22, 2022 in DevOps on Cloud by Edureka
• 13,800 points
2,322 views
0 votes
0 answers

Azure devops pipeline variable for a task step name

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

Jan 5, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,718 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,473 views
0 votes
0 answers

gradlew will not sign a debug build

I am working on a CICD pipeline ...READ MORE

Jan 12, 2023 in AWS by Tejashwini
• 5,380 points

edited Mar 4, 2025 1,418 views
0 votes
1 answer

What are the -Xms and -Xmx parameters when starting JVM?

The XMX parameter helps in signifying and ...READ MORE

Feb 8, 2022 in Java by Soham
• 9,730 points
15,959 views
0 votes
1 answer

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML():   Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

Dec 29, 2022 in Others by narikkadan
• 86,360 points
2,001 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 86,360 points
1,592 views
0 votes
0 answers

i want to use one formula which can fill the row table as per same cell but from different worksheets?

same cell in excel from different worksheets ...READ MORE

Jan 31, 2023 in Others by pramod

edited Mar 4, 2025 557 views
0 votes
1 answer

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,459 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,458 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
1,539 views
0 votes
0 answers

the best IT speciality for a 40 years old discharged military officer to learn

My career in the armed comes to ...READ MORE

Jan 21, 2023 in Ask us Anything! by anonymous

edited Mar 4, 2025 991 views
0 votes
1 answer

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

Dec 19, 2022 in Others by narikkadan
• 86,360 points
2,357 views
0 votes
0 answers

Unauthorized error with git tfs list-remote-branches

I have a repo in Azure Devops ...READ MORE

Jan 5, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,682 views
0 votes
1 answer

Excel plot time series frequency with continuous xaxis

Excel has a few oddities that must ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 86,360 points
4,205 views
0 votes
0 answers

How to convert xml to csv file

The data in xml file is someting ...READ MORE

Jan 29, 2023 in Python by Wu

edited Mar 4, 2025 629 views
0 votes
0 answers

Most relevant learnings to radio communications speciality

I come from the military communication field ...READ MORE

Jan 21, 2023 in Career Counselling by anonymous

edited Mar 4, 2025 978 views
0 votes
1 answer

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

Oct 11, 2022 in Others by narikkadan
• 86,360 points
5,371 views
0 votes
1 answer

iOS : Black screen appears when run my app

Go For Force Restart If it is a ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
• 25,250 points
2,859 views
0 votes
0 answers

How to display and raise warnings in release pipeline for Azure devops?

I'm running a Python script in my ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Nicholas
• 7,760 points
2,652 views
0 votes
1 answer

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

Dec 15, 2022 in Others by narikkadan
• 86,360 points
2,544 views
0 votes
1 answer

Excel Formula: Count cells where value is date

Dates in Excel are just formatted numbers, ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 86,360 points
2,717 views
0 votes
1 answer

Convert image (jpg) to base64 in Excel VBA?

Heres a function. Can't remember where I ...READ MORE

Sep 27, 2022 in Others by narikkadan
• 86,360 points
5,973 views
0 votes
0 answers

Origin of the C# language name

Programmer in C and C++, currently attempting ...READ MORE

Sep 20, 2022 in C# by Edureka
• 13,800 points
1,665 views
0 votes
1 answer

Highlight active row/column in Excel without using VBA?

Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 86,360 points
4,651 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 86,360 points
1,487 views
0 votes
0 answers

AWS CDK - get ProvisioningArtifactIds from ServiceCatalog product

In CDK I couldn't find from documentation ...READ MORE

Dec 15, 2022 in AWS by Tejashwini
• 5,380 points
2,535 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
1,399 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 86,360 points
1,267 views
0 votes
1 answer

Get random value in the range of plus/minus 10% of a cell value in Excel

Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE

Dec 25, 2022 in Others by narikkadan
• 86,360 points
2,086 views
0 votes
0 answers

How to download the content of a directory in Azure Storage using az storage fs directory?

Currently, I'm using az storage blob  ...READ MORE

Dec 19, 2022 in DevOps on Cloud by Damonlang
• 1,230 points
2,272 views
0 votes
0 answers

i am having an error called identifier not found or not unique.

i have called a function for owner ...READ MORE

Dec 19, 2022 in Blockchain by virat

edited Mar 4, 2025 2,362 views
0 votes
1 answer

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

Dec 24, 2022 in Others by narikkadan
• 86,360 points
2,122 views
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

Nov 25, 2022 in Others by narikkadan
• 86,360 points
3,372 views
0 votes
1 answer

Excel countif entire row in a table

Try this: =COUNTIF(B:B,"my citeria") so if your Column ...READ MORE

Dec 25, 2022 in Others by narikkadan
• 86,360 points
2,075 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

Dec 25, 2022 in Others by narikkadan
• 86,360 points
2,072 views
0 votes
1 answer

How to validate values entered in a multiline Excel cell?

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

Jan 13, 2023 in Others by narikkadan
• 86,360 points
1,247 views
0 votes
0 answers

Use camera flashlight in Android

I'm trying to use the cameras LED ...READ MORE

Nov 23, 2022 in Android by Ashwini
• 5,440 points
3,319 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

Jan 9, 2023 in Others by narikkadan
• 86,360 points
1,412 views
0 votes
0 answers

TypeError: not all arguments converted during string formatting python

The program is supposed to take in ...READ MORE

Dec 22, 2022 in Python by erzan
• 630 points
2,225 views
0 votes
1 answer

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 86,360 points
1,586 views
0 votes
0 answers

phpMyAdmin access denied for user 'root'@'localhost' (using password: NO)

I am having this error when I ...READ MORE

May 30, 2022 in PHP by Kichu
• 19,040 points
11,068 views
0 votes
1 answer

ASP.NET generated excel file has different format than extension

You must include the xlsx file extension. The ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 86,360 points
1,573 views
0 votes
1 answer

Get selected value of a dropdown's item using jQuery

Use the jQuery: selected selector in combination ...READ MORE

Jun 3, 2022 in JQuery by Edureka
• 13,690 points
10,881 views
0 votes
0 answers

Can we automate React app using selenium?

Can we automate React app using selenium? READ MORE

Jan 19, 2023 in Selenium by Sukanya

edited Mar 4, 2025 978 views
0 votes
1 answer

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

If not already done, save and close ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 86,360 points
1,474 views