Trending questions in Edureka Community

0 votes
0 answers

How can I take the square root of -1 using python?

When I take the square root of ...READ MORE

Feb 17, 2023 in Python by Arya
 • 990 points
edited Mar 5, 2025 • 361 views
0 votes
0 answers

Print series of prime numbers in python

I was having trouble printing a run ...READ MORE

Feb 17, 2023 in Python by Arya
 • 990 points
edited Mar 5, 2025 • 354 views
0 votes
0 answers

How to declare and add items to an array in Python?

I'm trying to add items to an ...READ MORE

Feb 16, 2023 in Python by Arya
 • 990 points
edited Mar 4, 2025 • 392 views
0 votes
1 answer

How do I find top row visible on Sheet in Excel

Try this: ? Activewindow.VisibleRange.Row READ MORE

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

My VBA macro slows down dramatically with each use

You have a function called ExportRange that ...READ MORE

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

Get the query string value and display it in my html page

I can see the query string values ...READ MORE

Jul 21, 2022 in HTML by Ashwini
 • 5,430 points • 2,532 views
0 votes
1 answer

How do I show the computations after S/N 1048576 in a separate sheet

Add: If xRg.Row = xRg.Parent.Rows.Count Then ...READ MORE

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

Azure pipeline dynamic creation of variables based on parameters

I've included an azure-pipeline.yml file that references ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 2,275 views
0 votes
0 answers

Getting exception while trying to build SsmClient from aws-sdk-java version 2

The exception I am getting -- java.lang.NoClassDefFoundError: org/apache/http/impl/client/DefaultClientConnectionReuseStrategy at ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
 • 5,380 points • 1,370 views
0 votes
1 answer

How to show a row in excel if there is a X

FILTER Function: "filters" a range of data ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 954 views
0 votes
1 answer

VBA to protect and unprotect in given range in sheet

It needs a minor tweak to become ...READ MORE

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 3,981 views
0 votes
1 answer

Python Math - TypeError: 'NoneType' object is not subscriptable

“TypeError: 'NoneType' object is not subscriptable” is ...READ MORE

Jan 4, 2023 in Python by Elton
 • 400 points • 2,200 views
0 votes
1 answer

VBA Range.Offset Error 1004 Range beyond scope of sheet Dynamic Range

Check the .Row first: With Sheets("Line 3").Range("G1024").End(xlUp) ...READ MORE

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

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 15,997 views
0 votes
1 answer

Vanilla JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it

Use Internet Explorer 9 or later if you're using VANILLA pure JavaScript without jQuery. document.addEventListener("DOMContentLoaded", function(event) { // ...READ MORE

Nov 8, 2022 in Java by Damonlang
 • 700 points • 4,654 views
0 votes
1 answer

Using createobject("Excel.application") to create excel 2007 application

Try the next adapted way. No need ...READ MORE

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

Extracting info from hyperlink

This will offer you an example of ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 931 views
0 votes
0 answers

import .cert file to azure keyvault issues

I added a.cert certificate to Azure DevOps ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 720 views
0 votes
1 answer

Open SAP from Excel VBA

It just means that there is no ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 6,342 views
0 votes
1 answer

how to use json file in html code?

<html> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"> </script> <script> ...READ MORE

Aug 8, 2022 in HTML by Vikas
 • 8,651 views
0 votes
1 answer

Excel VBA userform paste text in expanded format (not just to one cell)

It should work if you simply supply ...READ MORE

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

Is there a way to import multiple repos at once from github into azure devops?

I would like to transfer a github&nbs ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 710 views
0 votes
0 answers

how to list GCP Project in subfolders

Hi, I want to list all GCP projects ...READ MORE

Feb 15, 2023 in GCP by MGX
edited Mar 4, 2025 • 393 views
0 votes
1 answer

How to extract text before the last "," in excel formula?

Using FILTERXML() • Formula used in cell B1 =FILTERXML("<m><b>"&SUBSTITUTE(A1,", ","</b><b>")&"</b></m>","//b[last()-1]") You can ...READ MORE

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

I am trying to configure and install puppet on a slave node but to no avail. The error message is shown below.

+ sudo dpkg -i puppetlabs-release-pc1-xenial.deb sudo: no tty ...READ MORE

Feb 9, 2023 in Puppet by Ferdinand
edited Mar 4, 2025 • 631 views
+1 vote
2 answers

Which is better for my career further: DevOps or Data Science?

Hello, Willing to know Data Science salary and ...READ MORE

Feb 14, 2022 in Career Counselling by Emily Hilton
 • 32,386 views
0 votes
1 answer

Pivoting 4x4 into 16x1

Try this: df <- tibble::tribble( ~ID, ~sit1, ...READ MORE

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

EXCEL: Auto number rows until value in cell

You can utilize SEQUENCE if you have ...READ MORE

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

How to do multiple transpose in excel vba

Use Dictionary object Sub test2() With New ...READ MORE

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

How to link two excel sheet in same excel file

It would be best if you made ...READ MORE

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

VBA Insert row instead of copy

Try this: Option Explicit ' declare all variables Sub ...READ MORE

Jan 14, 2023 in Others by narikkadan
 • 86,360 points • 1,708 views
–1 vote
1 answer

Error response from daemon: This node is not a swarm manager. Use "docker swarm init" or "docker swarm join" to connect this node to swarm and try again.

docker swarm init --advertise-addr  192.168.99.1 READ MORE

Jun 3, 2022 in Docker by anonymous
edited Mar 5, 2025 • 25,550 views
0 votes
1 answer

Split and group values in excel

variant using scripting.dictionary: Sub test() Dim ...READ MORE

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

Unable to build the ASP.Net Core 7 in azure devops pipeline (CI)

ASP.Net Core 7 cannot be built in&nbs ...READ MORE

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

VBA How To Paste With Blank One Column Over?

Try this: Option Explicit Sub CopyPaste() ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 1,181 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
 • 86,360 points • 2,785 views
0 votes
1 answer

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

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

white screen on simulator iphone Xcode

After creating the request, you must actually ...READ MORE

Sep 20, 2022 in Others by Aditya
 • 7,680 points • 6,703 views
0 votes
1 answer

How do I get it to select a single row based on the value?

Try this: Sub MoveBasedOnValue2() Dim ...READ MORE

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

my access to my course has been taken.

My access to my course has been ...READ MORE

Feb 13, 2023 in DevOps & Agile by Oumar
edited Mar 4, 2025 • 389 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
 • 86,360 points • 2,067 views
0 votes
1 answer

Iterate thru specific controls in a form using a loop

The textbox numbers you want to iterate ...READ MORE

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

Excel VBA move pivot item to last position

Try this: Sub Tester() Dim ...READ MORE

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

Get inserted image to adjust the row height in Excel

Try this: 'just find Photo1 cell and select ...READ MORE

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

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

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

Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

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

Need a formula that will pull the specific value that matches a unique code from a set of data and produce another table of that specific data

VLOOKUP will work: vlookup =VLOOKUP(G2,$A$2:$D$11,3,FALS ...READ MORE

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

Excel convert multiple columns to dataset based on unique timestamp

F2 =UNIQUE($B$2:$B$20) G2 =FILTER($C$2:$C$20;($B$2:$B$20=$F2)*($A ...READ MORE

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

Trying to run different macros based on value of cell in a range

This demonstrates one approach to loop through ...READ MORE

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

Unable to negotiate with 40.74.28.9 port 22: no matching host key type found. Their offer: ssh-rsa

When using git within Azure DevOps repositories ...READ MORE

Dec 13, 2022 in Git & GitHub by Edureka
 • 12,730 points • 3,068 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.