Trending questions in Edureka Community

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,317 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,367 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,366 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,363 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,665 views
+3 votes
3 answers

How can we hack gmail id with the use of fishing attack with out use of gmail password

Aaaaaaaaaaaa READ MORE

Mar 3, 2023 in Cyber Security & Ethical Hacking by Farman Fazil
edited Mar 5, 2025 • 20,228 views
+1 vote
12 answers

How to check size of HDFS directory?

It is the same syntax. Use the ...READ MORE

Jun 6, 2019 in Big Data Hadoop by Sowmya
 • 54,145 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,105 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,560 views
0 votes
1 answer

How to use useState hook in React with typescript correctly?

You can set a string type for it Explicit way: const ...READ MORE

Aug 3, 2022 in TypeSript by Abhinaya
 • 1,160 points • 8,229 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,424 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 • 1,875 views
0 votes
1 answer

Why is `(True, True, True) == True, True, True` not True in Python?

Operator precedence. You're actually checking equality between (True, ...READ MORE

Jan 4, 2023 in Python by Elton
 • 400 points • 1,593 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,453 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,242 views
0 votes
1 answer

Make certain characters in an Excel cell subscript Python

With Xlwings, you may accomplish this by ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 2,530 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,185 views
0 votes
2 answers

What is the difference between Set and List in java?

List is an ordered sequence of elements. ...READ MORE

Apr 26, 2018 in Java by Akrati
 • 3,190 points • 65,292 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,730 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 86,360 points • 6,034 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,155 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,183 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,730 points • 1,552 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,336 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,381 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,219 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,523 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,149 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,516 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,492 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,259 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,430 points • 3,217 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,831 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 • 900 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,487 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,003 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,566 views
0 votes
0 answers

Connect to RDS through VPC Peering

I'm attempting to establish a VPC Peering ...READ MORE

Jan 18, 2023 in AWS by Tejashwini
 • 5,380 points
edited Mar 4, 2025 • 941 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 • 1,957 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,264 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 • 1,955 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,788 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,227 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,383 views
0 votes
1 answer

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 15,609 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 • 1,939 views
0 votes
0 answers

Why am i being charged for amazon web services

So I created my free account on ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
 • 100 points
edited Mar 4, 2025 • 704 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,410 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

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

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 86,360 points • 1,271 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.