Trending questions in Edureka Community

0 votes
1 answer

Remove the Rupee symbol in Laravel

Although there are other approaches you may ...READ MORE

Jan 6, 2023 in Others by narikkadan
• 86,360 points
2,027 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 86,360 points
681 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,730 points
58,012 views
0 votes
1 answer

Selecting a value of a table in Excel

Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE

Feb 7, 2023 in Others by narikkadan
• 86,360 points
629 views
0 votes
0 answers

Syncing profile pictures from Azure Active Directory to Azure DevOps

I have an Azure DevOps organization linked ...READ MORE

Mar 20, 2022 in Other DevOps Questions by Kichu
• 19,040 points
1,193 views
0 votes
1 answer

How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

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

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

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

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE

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

How to replace negative numbers in Pandas Data Frame by zero?

 If all your columns are numeric, you ...READ MORE

Dec 16, 2020 in Python by Rajiv
• 8,870 points
45,699 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
• 86,360 points
6,970 views
+2 votes
2 answers

ImportError: numpy.core.multiarray failed to import

try this... run this code one by one.... pip ...READ MORE

Nov 5, 2020 in Python by Anand Vijay Rajsri

reshown Nov 5, 2020 by Sirajul 38,992 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

Application.DisplayStatusBar = True Is cancelling your ...READ MORE

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

Laravel - Connection could not be established with host smtp.gmail.com [ #0]

While using the Laravel project directory, edit ...READ MORE

Feb 22, 2022 in Others by Aditya
• 7,680 points
15,689 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
• 86,360 points
5,002 views
0 votes
1 answer

How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 86,360 points
807 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
• 86,360 points
1,102 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

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

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
• 86,360 points
5,160 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
• 86,360 points
1,919 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,791 views
0 votes
0 answers

Get target group arn from aws cli

I'm attempting to obtain the arn of a target group whose name contains the word "test" or the value assigned to "value," but I'm having trouble because I keep getting this problem. value=test aws elbv2 describe-target-groups --query "TargetGroups[?starts_with(TargetGroupName, '${value}') == ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points
1,198 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
• 86,360 points
911 views
0 votes
0 answers

Calendar React JS

I have a homework to make a ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 5,380 points
1,059 views
0 votes
0 answers

How can I use a Linked List in Python?

How can I utilise a linked list ...READ MORE

Feb 17, 2023 in Python by Arya
• 990 points

edited Mar 4 152 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,293 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
• 86,360 points
1,808 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
• 86,360 points
639 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
• 86,360 points
900 views
0 votes
0 answers

Cannot find class in classpath in selenium

[RemoteTestNG] detected TestNG version 7.4.0 org.testng.TestNGException: Cannot find ...READ MORE

Feb 17, 2023 in Selenium by Tinju

edited Mar 4 145 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
• 86,360 points
1,286 views
0 votes
0 answers

How to implement XRay in NodeJS project?

I need to create XRay to collect ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points
1,179 views
+1 vote
1 answer

ModuleNotFoundError: No module named 'keras'

Hi@akhtar, I think this problem is related to ...READ MORE

Apr 23, 2020 in Machine Learning by MD
• 95,460 points

edited Aug 11, 2021 by Soumya 44,542 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
• 86,360 points
892 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
• 86,360 points
1,061 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 178 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 134 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 128 views
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 126 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
• 86,360 points
616 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
• 86,360 points
702 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 120 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
• 86,360 points
826 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
• 86,360 points
1,251 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 140 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 160 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 134 views
0 votes
1 answer

jQuery UI DatePicker to show month year only

Here's a hack (updated with entire .html ...READ MORE

Jun 2, 2022 in JQuery by Edureka
• 13,690 points
11,275 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 129 views
0 votes
1 answer

Excel Connect data points with line is DISABLED

By replicating the data series and substituting ...READ MORE

Dec 27, 2022 in Others by narikkadan
• 86,360 points
2,314 views