Trending questions in Edureka Community

0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 1,609 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 • 16,016 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,825 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,356 views
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,439 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,830 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,500 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,740 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,443 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,024 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,394 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,907 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,611 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,481 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,612 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,477 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,558 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,406 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 • 1,013 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,235 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 • 566 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,703 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 • 995 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 • 6,012 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 • 641 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,571 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,668 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,745 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,685 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,684 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,511 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,115 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,419 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,302 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,288 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,150 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,389 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,396 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,099 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,106 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,273 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,439 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,091 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,338 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,610 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,244 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,903 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,592 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,497 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 • 996 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.