Trending questions in Edureka Community

0 votes
1 answer

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 1,846 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,384 views
0 votes
0 answers

Get the name of a dynamo table created with AWS CDK

Using the example from here. I can create ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
 • 5,380 points • 1,807 views
0 votes
0 answers

dfd ffgfh zfggh zfxgfdgh zfgfgh zdfgh zdfg

dfd ffgfh zfggh zfxgfdgh zfgfgh zdfgh zdfgdfd ...READ MORE

Jan 20, 2023 in Azure by Rasel
 • 100 points
edited Mar 4, 2025 • 1,113 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,457 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,661 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,846 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,516 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,053 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,456 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,751 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,637 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,437 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,503 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,414 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,925 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,582 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,260 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,052 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,490 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,029 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 • 574 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,774 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,716 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,690 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,712 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 • 1,003 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,585 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 • 646 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,537 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,706 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,137 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,443 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,178 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,325 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,412 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,308 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,120 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,298 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,118 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,408 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,123 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,457 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,356 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,625 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,617 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,926 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,253 views
0 votes
0 answers

Using podman instead of docker for the Docker@2 task in Azure DevOps

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

Dec 15, 2022 in DevOps on Cloud by Nicholas
 • 7,760 points • 2,557 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,517 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.