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 54 views
0 votes
1 answer

How to return the last n number of values corresponding to a specific category?

Try: The formula in F3: =TAKE(SORT(FILTER(A:C,B:B=F1),1),- ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,600 points
547 views
0 votes
0 answers

How to find cube root using Python?

This is the best way I've found ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 5 51 views
0 votes
0 answers

Multiplication or sum of two numbers

Given two integer numbers, return their product ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 4 47 views
0 votes
1 answer

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

This works quite well for SQL min/max dates ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
6,828 views
0 votes
1 answer

Excel - return a value only if a condition is met via VBA

You could use IIf() DestSheet.Cells(erow, 9).Value = IIf(newuplift = ...READ MORE

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

Excel links keep crashing

When the links in the master sheet ...READ MORE

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

Microservices Architecture in NodeJS

It's great to hear that you're exploring ...READ MORE

Jun 2, 2023 in Node-js by anonymous
• 1,420 points
1,664 views
0 votes
0 answers

Sum of odd numbers using while loop in python

I'm new to programming, I was asked ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4 85 views
0 votes
1 answer

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

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

How to select from multiple tables without a JOIN ?

Try this: SELECT ... FROM ( SELECT ...READ MORE

Sep 12, 2022 in Database by narikkadan
• 63,600 points
6,854 views
0 votes
1 answer

Excel function to dynamically SUM UP data based on matching rows and columns

Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE

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

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

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

Change Data Source Range for ALL Pivot Tables that are Using a Particular Named Range Within Excel via VBA

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

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

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

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

Base language of Python

What is the base language used to ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4 64 views
0 votes
1 answer

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

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

Excel - How do I make rows that contain row headers into two columns

You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE

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

Oracle PL/SQL - ORA-01403 "No data found" when using "SELECT INTO"

Just populate the field directly, using ordering ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 63,600 points
6,579 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 55 views
0 votes
0 answers

"Develop a python program to print square root of every alternate number in the range 1 to 15." What Do You Mean by alternate number?

My most recent computer test had a ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4 53 views
0 votes
1 answer

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

Oct 28, 2022 in Others by narikkadan
• 63,600 points
4,825 views
0 votes
1 answer

Turning a .xlsx into multiple PDFs

You just need to adjust the font ...READ MORE

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

How to make login with Nodejs and MongoDB?

MongoDB Login and Registration with Node js ...READ MORE

Jun 16, 2022 in Node-js by Neha
• 9,020 points
10,605 views
0 votes
0 answers

Javascript remove background color and opacity

How can I delete the background-color  ...READ MORE

Dec 6, 2022 in Java by Nicholas
• 7,760 points
3,145 views
0 votes
1 answer

How to clear https proxy setting of NPM?

Hello @kartik, By running npm config rm proxy you remove ...READ MORE

Jul 14, 2020 in Node-js by Niroj
• 82,840 points
40,904 views
0 votes
0 answers

How to convert list to string [duplicate]

How can I use Python to turn ...READ MORE

Feb 16, 2023 in Python by Arya
• 990 points

edited Mar 4 44 views
0 votes
1 answer

Successive retrieval of defined ranges, by splitting thier names in a constant as well as a dynamic part

You can use a Select Case statement : Option Explicit Sub ...READ MORE

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

Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

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

iOS 13 Custom Fonts download and installation

Step 1: From the Home screen, tap ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
• 23,260 points
3,213 views
0 votes
0 answers

How would I get ChatGPT to receive messages from Minecraft chat and return messages?

Just out of curiosity!!! How could you use ...READ MORE

Feb 15, 2023 in ChatGPT by erzan
• 630 points

edited Mar 4 57 views
0 votes
1 answer

Append same text to every cell in a column in Excel

Solution All your data is in column A ...READ MORE

Oct 17, 2022 in Others by narikkadan
• 63,600 points
5,273 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

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

Project ID printed for every task on the API problem

Try this: def teste(id): listID = ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,600 points
589 views
0 votes
0 answers

Retrieving data from Azure Mobile Services

When I try to retrieve data for ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points

edited Mar 4 87 views
0 votes
1 answer

Could not open input file: artisan

chmod + artisan READ MORE

Aug 8, 2022 in Other DevOps Questions by anonymous

edited Mar 5 10,377 views
0 votes
0 answers

org.openqa.selenium.NoSuchElementException: Timed out after 10 seconds. Element not found

Getting "org.openqa.selenium.NoSuchElementException: Timed out after 10 seconds. ...READ MORE

Feb 14, 2023 in Selenium by anonymous

edited Mar 4 84 views
0 votes
1 answer

How to gentrate Unique Id in ReactJs

You can use useId to create a ...READ MORE

Feb 8, 2023 in Others by Damonlang
• 1,230 points
556 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 63,600 points
1,443 views
0 votes
0 answers

How to properly send a GraphQL update request using Axios?

I created an application using AWS Amplify, ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 3,820 points
984 views
0 votes
1 answer

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

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

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

VBA code to select only a table. I am getting a Run-time error '1004'; Method 'Range' of object'_Global' failed

No copy/paste, just direct assignment use.Value Sub Final_Report() ...READ MORE

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

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 63,600 points
6,723 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 48 views
0 votes
1 answer

VBA reordering columns from different workbook or sheet

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

Feb 4, 2023 in Others by narikkadan
• 63,600 points
474 views
0 votes
0 answers

nodemon app crashed - waiting for file changes before starting

The node is crashing when I access ...READ MORE

May 13, 2022 in Angular by Kichu
• 19,040 points
8,853 views
0 votes
1 answer

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

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

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 63,600 points
505 views