Trending questions in Edureka Community

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
 • 63,600 points • 802 views
0 votes
1 answer

Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,600 points • 885 views
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
 • 63,600 points • 794 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
 • 63,600 points • 574 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
 • 3,820 points • 1,111 views
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
 • 63,600 points • 1,867 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

Jan 19, 2023 in Others by narikkadan
 • 63,600 points • 1,300 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
 • 63,600 points • 480 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
 • 63,600 points • 776 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 • 64 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
 • 63,600 points • 601 views
0 votes
0 answers

Calendar React JS

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

Jan 27, 2023 in Others by Tejashwini
 • 3,820 points • 966 views
0 votes
1 answer

Automating production of graphs using VBA

You have to change: chrtname = Cells(i, 2).Value To: chrtname ...READ MORE

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

Excel VBA - Subscript Out of Range Error (Run Time: Error 9)

Set rangePartner = Range(Partner.Cells(2, 2), Partner.Cells(2, 2).End(xlDown)) Needs ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 63,600 points • 1,196 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,022 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 • 537 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 • 41 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 • 38 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 • 37 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 • 33 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 • 787 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 • 31 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 • 956 views
0 votes
0 answers

Javascript Arrays Opposite of Includes

What is the proper approach to remove ...READ MORE

Aug 8, 2022 in TypeSript by krishna
 • 2,820 points • 3,763 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 • 70 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
 • 3,820 points • 1,061 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,645 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 • 773 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,153 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 • 53 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 • 760 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,661 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 • 582 views
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,827 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 • 41 views
0 votes
1 answer

Failed to load resource: the server responded with a status of 500 (Internal Server Error) in Bind function

The 500 code gets the error and ...READ MORE

Apr 29, 2022 in Other DevOps Questions by narikkadan
 • 63,600 points • 12,693 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,777 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 • 920 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,740 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 • 34 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 • 30 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,798 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,121 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 • 689 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 • 469 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,119 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 • 45 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,182 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 • 534 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.