Trending questions in Edureka Community

0 votes
1 answer

how to Convert EST time to IST time in excel?

Use the following calculation since Indian Standard ...READ MORE

Mar 30, 2022 in Database by gaurav
 • 23,580 points • 14,369 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, 2025 • 309 views
0 votes
1 answer

Modifying CSV files from a local folder-VBA

Solution  You need to fully qualify your Columns object ...READ MORE

Jan 17, 2023 in Others by narikkadan
 • 86,360 points • 1,625 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
 • 86,360 points • 841 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 • 4,642 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 • 300 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,378 views
0 votes
1 answer

2D rotation of an object along a custom axis

Use this: Option Explicit Type ObjLocData ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 1,008 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 • 338 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,086 views
0 votes
1 answer

DevOps: Epics and Features not showing up in Plan

Work items and dependency lines must appear ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
 • 220 points • 2,207 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,210 views
+1 vote
1 answer

How to rename Docker images without rebuilding it?

Hi@akhtar, You can rename your docker image by ...READ MORE

May 19, 2020 in Docker by MD
 • 95,460 points • 43,553 views
0 votes
1 answer

Historical Yahoo Finance API On Fritz Again?

It appears that Yahoo updated its finance ...READ MORE

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

Copy the time to the next row of another column

Try this: Sub CopyCurrentTime() Dim currentRow As Integer currentRow = ...READ MORE

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

SQL Server Error : String or binary data would be truncated

You're trying to write more data than ...READ MORE

Sep 15, 2022 in Database by narikkadan
 • 86,360 points • 6,986 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,404 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,192 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 • 880 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,293 views
0 votes
1 answer

Convert Date format into DD/MMM/YYYY format in SQL Server

Using convert() and style 106, you can ...READ MORE

Feb 23, 2022 in Database by Vaani
 • 7,070 points • 15,713 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,311 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,186 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 • 868 views
0 votes
0 answers

java.sql.SQLException: Missing IN or OUT parameter at index:: 1

Using OJDBC 6, I created some Java ...READ MORE

Aug 15, 2022 in Database by Kithuzzz
 • 38,000 points • 8,189 views
0 votes
1 answer

Public variable for captura path in vba excel

An assignment statement (as ruta = ActiveWorkbook) ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 1,341 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,383 views
0 votes
1 answer

Excel formula to calculate MIN in table filtered

Try this: =SUBTOTAL(105;B2:B7) READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 991 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,750 points • 4,574 views
0 votes
1 answer

How to set formula in Excel with POI?

Microsoft Excel only stores en US formula ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 86,360 points • 1,632 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,373 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 • 334 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,011 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,311 views
0 votes
1 answer

Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

 There were multiple issues. If you encounter ...READ MORE

Sep 13, 2022 in Database by narikkadan
 • 86,360 points • 6,992 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 • 631 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,043 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 • 962 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 • 559 views
0 votes
1 answer

Separate full address into street address, city, state, zip, country in excel

This macro contains the functions Split() and IsNumeric(), it's all ...READ MORE

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

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

This is my Stored procedure : CREATE PROCEDURE ...READ MORE

Aug 14, 2022 in Database by Kithuzzz
 • 38,000 points • 8,234 views
0 votes
1 answer

Windows 10 IE is not working with old VBA code

I discovered the answer. The issue was ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 2,547 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,750 points • 1,273 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 • 341 views
0 votes
1 answer

Excel - Separating text with numbers, text and brackets into separate cells

You can try FILTERXML(). READ MORE

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

Excel: Is it possible to reorder the data in 2 columns to match up if they have a certain number of characters / a string in common?

Try this: =LET(files,A1:A4, URLs,B1:B4, f,BYROW(files,LAMBDA(r,TEX ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 1,325 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 • 976 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 • 889 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 • 972 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 • 966 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.