Trending questions in Edureka Community

0 votes
1 answer

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,600 points • 1,297 views
+1 vote
0 answers

How to deploy a NestJS application which is in a Nx monorepo?

I'm working on a Nx monorepo that ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
 • 3,820 points • 1,042 views
0 votes
0 answers

Excel VBA: Open Hyperlinks in a loop and copy paste download link in a sheet

I want to click on a number ...READ MORE

Dec 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,480 views
0 votes
1 answer

Insert Excel rows for each x in adjacent country columns to prepare Oracle Calendar Event Coverage uploadsheet

Create a table (insert > table) from ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 63,600 points • 569 views
0 votes
0 answers

login system via on localhost not working

I have a login system built and ...READ MORE

Jun 20, 2022 in PHP by Kithuzzz
 • 38,000 points • 1,559 views
–1 vote
1 answer

Git: cannot checkout branch - error: pathspec '…' did not match any file(s) known to git.

Hi@MD, You can try the git fetch command ...READ MORE

Jan 4, 2021 in Git & GitHub by akhtar
 • 38,260 points • 30,093 views
0 votes
0 answers

How do I change timezone in a docker container?

I'm running a docker container from docker-hub ...READ MORE

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

Excel formula to convert number to both feet and inches

If you want the answer to be ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 912 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 63,600 points • 774 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 4,235 views
0 votes
0 answers

Yesterday Used jenkins practiced well, today while opening jenkins getting error

java.io.IOException: Permission denied at java.base/java.io.UnixFileSystem.createFileExclusively(Native Method) at java.base/java.io.File.createTempFile(File.java:2129) at hudson.util.AtomicFileWriter.<init>(AtomicFileWriter.java:143) Caused: ...READ MORE

Jan 25, 2023 in Jenkins by anonymous
edited 5 days ago • 111 views
0 votes
0 answers

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I experimented with the following code in ...READ MORE

Aug 22, 2022 in Database by Kithuzzz
 • 38,000 points • 6,794 views
0 votes
1 answer

Consolidate orders to single row counting number of orders and averaging the result

Try this: Sub aveCount() Dim rng As Range Dim cl ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 63,600 points • 424 views
0 votes
1 answer

Excel - Stack Data based in Condition

Try this : =TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss") It appears you tried Filter ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 63,600 points • 549 views
0 votes
0 answers

namenode not running

when i execute command start-all.sh it does ...READ MORE

Jan 25, 2023 in Big Data Hadoop by Pramod
edited 5 days ago • 96 views
0 votes
1 answer

Is there a hierarchy inferring algorithm available in python?

Convert the list of values to the ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,600 points • 500 views
0 votes
1 answer

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,600 points • 1,018 views
0 votes
1 answer

How to freeze the =today() function once data has been entered

Don't enter this formula: =TODAY() Instead use  Ctrl + ; This will put a "frozen" ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,600 points • 1,752 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,620 points • 1,554 views
0 votes
1 answer

Excel COUNTIFS with merged cell

Although it is strongly advised to stay ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,600 points • 1,320 views
0 votes
1 answer

Return blank cell only if referred cell is blank, but return aging if date is entered

Try this: =IF(ISBLANK(AC2),"",TODAY()-AC2) The TODAY  function automatically refreshes based ...READ MORE

Dec 17, 2022 in Others by narikkadan
 • 63,600 points • 1,749 views
0 votes
1 answer

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 924 views
0 votes
3 answers

Command "python setup.py egg_info" failed with error code 1 in C:\Users\Nadeem\AppData\Local\Temp\

You have an out of date version ...READ MORE

Dec 15, 2020 in Python by Rajiv
 • 8,870 points • 38,113 views
0 votes
1 answer

Excel cannot open the file because the file format or file extension is not valid - PHP Maatwebsite

Try this: if (ob_get_length() == 0 ) { ...READ MORE

Dec 19, 2022 in Others by narikkadan
 • 63,600 points • 1,618 views
0 votes
1 answer

All Levels of a Factor in a Model Matrix in R

Yes, you can modify the model.matrix() function ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 1,150 views
0 votes
1 answer

Excel - External link to multiple workbooks

Try the INDIRECT() function. But this won't automatically update ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 63,600 points • 529 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,600 points • 445 views
0 votes
1 answer

Name for excel graph problem with the vba generator

Change the name of the workbook : Sub Macro_name_graph2() ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,600 points • 829 views
0 votes
1 answer

How to subtract dates in Excel with different date formats?

You can use dates in any computation ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,600 points • 1,234 views
+1 vote
0 answers

How do I import Ant Design React UI library and css?

I am very new to UI libraries ...READ MORE

Jul 22, 2022 in CSS by Edureka
 • 13,620 points • 4,216 views
0 votes
1 answer

Excel Count if with index match

Try this: Countif(Index(rangeoflookupvalues,,match(Columnvaluetobe ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 2,050 views
0 votes
1 answer

How to turn on front flash light programmatically in Android?

For this problem you should: Check whether the ...READ MORE

Nov 8, 2022 in Android by Edureka
 • 12,690 points • 3,472 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 14,522 views
0 votes
0 answers

Which of these tools is not associated with DevOps?

Which of the following tools are not ...READ MORE

Dec 12, 2022 in DevOps Tools by Edureka
 • 12,690 points • 1,412 views
0 votes
1 answer

Copy formula from Excel to Notepad++

If you go to Formulas card, inside Formulas Auditing section there ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 63,600 points • 1,888 views
0 votes
1 answer

Excel Power Query Group by

Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,600 points • 589 views
0 votes
1 answer

Is it possible to see more than 65536 rows in Excel 2007?

Here is an interesting blog entry about the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 2,032 views
0 votes
1 answer

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,600 points • 587 views
0 votes
0 answers

I wrote this function but it returned only the false and not the true but I have "PROOF" in the ABV (3) FIELD

IF(BEER[ABV (3)]="PROOF",CONVERT(DIVIDE(BEER[Column TRY],2,0),STRING),BEER[ABV (3)]). Please what is ...READ MORE

Jan 26, 2023 in Power BI by Frederick
edited 5 days ago • 15 views
+1 vote
1 answer

How to rename Docker images without rebuilding it?

Hi@akhtar, You can rename your docker image by ...READ MORE

May 19, 2020 in Docker by MD
 • 95,460 points • 42,315 views
0 votes
1 answer

Reading Excel file using node.js

Several distinct libraries perform Excel file parsing ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 2,238 views
0 votes
1 answer

Trying to make my VBA run a little bit faster

Using Variables In regards to efficiency, that's about ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 63,600 points • 785 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Using OJDBC 6, I created some Java ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 6,980 views
0 votes
1 answer

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,600 points • 647 views
0 votes
1 answer

ERROR 1142 (42000): SELECT command denied to user ''@'localhost' for table 'user'

Hey, This is a mysql command line error ...READ MORE

Jun 20, 2019 in Big Data Hadoop by Gitika
 • 65,770 points • 56,807 views
0 votes
1 answer

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 63,600 points • 555 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 • 874 views
0 votes
1 answer

Use python to remove blank cells from column and shift populated cells up

Use pandas to import and modify your excel. import pandas ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 63,600 points • 2,205 views
0 votes
1 answer

Excel Conditional Formating to find numbers a cell with text

Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE

Jan 10, 2023 in Others by narikkadan
 • 63,600 points • 627 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 • 862 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.