Trending questions in Edureka Community

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
• 86,360 points
1,570 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, 2025 895 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
1,481 views
0 votes
0 answers

React useEffect Hooks with setTimeout

I am so confused here with React ...READ MORE

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

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

Nov 8, 2022 in Others by narikkadan
• 86,360 points
5,100 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
1,340 views
0 votes
1 answer

Formula to count if a text is written in a cell

Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE

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

related to jar files

Unable to initialize main class com.tectoro.codocs.ca.Application Caused by: ...READ MORE

Feb 23, 2023 in Java by Humera

edited Mar 5, 2025 492 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
2,282 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
1,505 views
0 votes
0 answers

i actually created a bean in spring context,when i get that bean there is an error msg NoSuchBeansDefinationException

package com.learningSpring.learningSpring; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; @Configuration public class HelloWorldConfiguration { ...READ MORE

Feb 21, 2023 in Java by anonymous

edited Mar 5, 2025 572 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
• 86,360 points
1,323 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
1,279 views
0 votes
0 answers

Determining whether an value is a whole number in Python

I would like to determine if a ...READ MORE

Feb 22, 2023 in Python by Arya
• 990 points

edited Mar 5, 2025 512 views
0 votes
1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

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

Jan 23, 2023 in Others by narikkadan
• 86,360 points
1,792 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,772 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,778 views
0 votes
1 answer

Divide a range of values for each unique value

With the next available row as the ...READ MORE

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

Passing azure secret variables to pytest in pipeline?

We are using Azure Pipeline to run Python integration tests.  These tests make use of a database, and the login information is saved in an Azure variable group that also contains secret variables.  The integration tests are started in this section of the yaml file: jobs: - job: IntegrationTests variables: ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
• 1,230 points

edited Mar 4, 2025 1,149 views
0 votes
1 answer

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

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

Greenlet runtime error and deployed app in docker keeps booting all the workers

This is a warning message indicating that ...READ MORE

Feb 8, 2023 in DevOps on Cloud by Edureka
• 13,730 points
1,798 views
0 votes
1 answer

Excel 365 Formulas - How to save LAMBDA function permanently (for all existing and new files)?

Try creating a template for excel to ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 86,360 points
2,553 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
1,120 views
0 votes
0 answers

How can I implement a tree in Python?

How can I implement a general tree ...READ MORE

Feb 22, 2023 in Python by Arya
• 990 points

edited Mar 5, 2025 475 views
0 votes
0 answers

Is DevOps engineer a good job?

Can somebody tell me if working as ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,730 points
830 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
1,302 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 86,360 points
1,844 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
• 86,360 points
1,264 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
• 86,360 points
3,878 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
1,175 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
• 86,360 points
4,329 views
0 votes
1 answer

How to convert an XML file to an Excel file?

Create a CSV file that is in ...READ MORE

Jan 3, 2023 in Others by narikkadan
• 86,360 points
2,598 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
16,346 views
0 votes
0 answers

Java snapstart is not available in AWS Lambda

I have started to write Java Lambdas ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 5,380 points
1,747 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,704 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

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

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

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

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

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

Way to overcome Excel Vlookup function limit of 256 characters

If you are using VLOOKUP like this: =VLOOKUP(A2,D2:Z10,3,FALSE) i.e. ...READ MORE

Sep 30, 2022 in Others by narikkadan
• 86,360 points
6,702 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,528 views
0 votes
1 answer

PMT function in Javascript

Try the following settings to better understand ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 86,360 points
3,478 views
0 votes
0 answers
0 votes
0 answers

what machine learning model is used in chatgpt application?

It's just out of curiosity but which ...READ MORE

Feb 10, 2023 in ChatGPT by erzan
• 630 points

edited Mar 4, 2025 929 views
0 votes
1 answer

How get permission for camera in android.(Specifically Marshmallow)?

To begin with, confirm that the user ...READ MORE

Nov 8, 2022 in Android by Edureka
• 13,730 points
4,980 views
0 votes
0 answers

edureka certificate

Hi, I have joined in a course in ...READ MORE

Feb 20, 2023 in Python by A

edited Mar 5, 2025 506 views
0 votes
1 answer

Extracting specific columns from a data frame

Yes, there is a more efficient method ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
• 1,420 points
2,755 views
0 votes
0 answers

java.lang.NoClassDefFoundError: org/openqa/selenium/WebDriver

I added all the selenium  jars in ...READ MORE

Feb 10, 2023 in Selenium by anonymous

edited Mar 4, 2025 903 views
0 votes
1 answer

Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

I faced a comparable challenge. A bespoke ...READ MORE

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

Conditional Formating in Excel comparing dates between cells

To get a date from your strings, ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 86,360 points
1,535 views