Trending questions in Edureka Community

0 votes
1 answer

Relative imports in Python 3

Because the first statement, from.mymodule import myfunction, ...READ MORE

Feb 16, 2023 in Python by Rishu
• 300 points
1,083 views
0 votes
1 answer

How search data in excel with openpyxl?

The method iter_rows in the library has changed, refer ...READ MORE

Oct 2, 2022 in Others by narikkadan
• 63,680 points
7,012 views
0 votes
1 answer

I want to compare two Excel files and highlight the differences with VBA

The workbook doesn't have the UsedRange property ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 63,680 points
2,526 views
0 votes
1 answer

Lambda works locally, but not when deployed?

The error message you received when testing ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
1,014 views
0 votes
1 answer

Get column index from table header in excel

Try it. The StaffDetailsTbl table's headers are ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,020 points
745 views
0 votes
1 answer

How to copy entire data using row by row and paste to another sheet

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

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

Modifying Excel document using python and openpyxl

The style will be set to Hyperlink ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
998 views
0 votes
1 answer

After exporting ssrs report excel name should have todays date

If you use URL Access to generate the report, ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
1,320 views
0 votes
1 answer

Confused on VBA copy destination

Try this: Sub so75496418AddChart() Dim rng As Range Dim strTypeName ...READ MORE

Feb 20, 2023 in Others by Kithuzzz
• 38,020 points
840 views
0 votes
1 answer

Excel VBA select range

Please test the following event with adapted ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
974 views
0 votes
1 answer

Excel formula exceeds 8000 characters limit

Using auxiliary columns to divide the formula ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,680 points
786 views
0 votes
1 answer

'python' is not recognized as an internal or external command

There are multiple ways you can use: 1)Use ...READ MORE

Feb 16, 2022 in Python by Nandini
• 5,480 points
16,746 views
0 votes
1 answer

VLOOKUP to find weeknumber

Use  ISOWEEKNUM with the dates of the ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
958 views
0 votes
1 answer

Moving oldest files first from source to destination

You have to change the following line: If ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,680 points
649 views
0 votes
1 answer

Releasing COM-Object not necessary?

This place has infamously poor Office COM ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,680 points
643 views
0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 63,680 points
1,407 views
0 votes
1 answer

I keep getting a lot of errors on ChatGPT

Here are some of the common errors ...READ MORE

Feb 7, 2023 in ChatGPT by Elton
• 400 points
1,330 views
0 votes
1 answer

How to increment the Range of a For Each loop - Excel VBA

Your formula seems to sum 1 single ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 63,680 points
2,694 views
0 votes
1 answer

Excel VBA: how to find a description from an AD-group

First add the 'description' property to your ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
925 views
0 votes
1 answer

EXCEL: Count case sensitive criteria in one column if meets criteria in another column

You may try: The formula in B1: =MAP(A1:A12,LAMBDA(x,SUM(- ...READ MORE

Feb 24, 2023 in Others by narikkadan
• 63,680 points
605 views
0 votes
1 answer

Filter outlook sent items in vba failing for emails with multiple recipients

The PR DISPLAY TO parameter provides a ...READ MORE

Feb 21, 2023 in Others by narikkadan
• 63,680 points
730 views
0 votes
1 answer

Can I use ChatGPT to create chatbot on my website?

Yes, you can use ChatGPT to create ...READ MORE

Feb 15, 2023 in ChatGPT by anonymous
976 views
0 votes
0 answers

Azure DevOps Build Pipeline - Exclude a Folder from Code Coverage

I'm trying to exclude a folder from the code coverage analysis, but I'm not having any luck despite a lot of trial and error and research on this site. This is my build pipeline test task: - task: DotNetCoreCLI@2 displayName: 'Running Unit ...READ MORE

Dec 19, 2022 in DevOps on Cloud by Damonlang
• 1,230 points
3,493 views
0 votes
1 answer

Looping through a folder with Excel files and scraping date from selected cells usin VBA

You record the outcome of your comparison ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,680 points
934 views
0 votes
1 answer

Removing duplicates in lists

1)To get rid of duplicate items, convert ...READ MORE

Feb 16, 2023 in Python by Rishu
• 300 points
933 views
0 votes
1 answer
0 votes
1 answer

Error: 'int' object is not subscriptable - Python

int([x[age1]]) You are attempting to access the age1 index ...READ MORE

Feb 16, 2023 in Python by Rishu
• 300 points
922 views
0 votes
1 answer

Best way to do nested case statement logic in SQL Server

Try some sort of COALESCE trick: SELECT COALESCE( ...READ MORE

Sep 19, 2022 in Database by narikkadan
• 63,680 points
7,416 views
0 votes
1 answer

Why do I have heavy DeserializeSparse phase after EagerKernelExecutes on the multiple GPU training?

The heavy "DeserializeSparse" phase after the "EagerKernelExecutes" ...READ MORE

Feb 17, 2023 in AWS by anonymous
869 views
0 votes
1 answer

Delivering live streaming video with CloudFront and AWS Media Services

To connect your MediaPackage channel to CloudFront, ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
870 views
–1 vote
1 answer

How can i make money from ChatGPT?

As an individual user, you cannot directly ...READ MORE

Feb 15, 2023 in ChatGPT by anonymous
971 views
0 votes
1 answer

EXCEL Userform - Creating multiple Labels and Textboxes with specific names

Please, test the next scenario: Insert a class ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
1,200 views
0 votes
1 answer

how to fix ChatGPT is at capacity right now on ChatGPT?

The message "ChatGPT is at capacity right ...READ MORE

Feb 9, 2023 in ChatGPT by Elton
1,161 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
969 views
0 votes
0 answers

Input Box Date Validation

I have an update form for my ...READ MORE

Feb 27, 2023 in Others by Kithuzzz
• 38,020 points
423 views
0 votes
1 answer

Degree of multiprogramming definition

In a multiprogramming-capable system, the jobs which ...READ MORE

Feb 11, 2022 in Others by Soham
• 9,710 points
16,810 views
0 votes
1 answer

How to calculate median of unsorted values

In vba code: Dim r As Range Dim result 'Set ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,020 points
550 views
0 votes
1 answer

Xcode not found in the PATH and expo cannot run iOS simulator

It sounds like you've encountered a few ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
812 views
0 votes
1 answer

VBA: My Email .body doesn't concatenate with itself: application-defined or object-defined error

Try this: 'Somewehere declare this string variable Dim incomingHTMLBody ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,680 points
847 views
0 votes
1 answer

Problem with connecting frontend and backend services through internal load balancer

It sounds like the communication between the ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
809 views
0 votes
1 answer

Function to filter excel table data in to a new dataset based on value defined in another table

If you just want to add up ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
806 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
1,050 views
0 votes
1 answer

Excel VBA search based on cell values into folders and sub-folders to get the file path and data

This will create a listing of all ...READ MORE

Jan 19, 2023 in Others by narikkadan
• 63,680 points
2,040 views
0 votes
1 answer

nodejs mysql Error: Connection lost The server closed the connection

Try to use this code to handle server disconnect: var ...READ MORE

Jun 17, 2022 in Node-js by Neha
• 9,020 points
11,340 views
0 votes
1 answer

Compress image up to maximum size(100kb) at NodeJS or React Native

Image Compression in React Native is a ...READ MORE

Apr 1, 2023 in Node-js by DSKView
• 180 points
5,577 views
0 votes
0 answers

Using SQL Stored Procedure vs Databricks in Azure Data Factory

ADF pipeline must be used to write ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
921 views
0 votes
1 answer

Writing large Excel in Java causing high CPU usage using apache-poi

Giving SXSSFWorkbook a window size appears to ...READ MORE

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

How do I get text in a pivot table in excel or google sheets?

Try: =QUERY(QUERY({Data!A:A, Data!Q:S}, "select Col4,max(Col1) ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 63,680 points
1,244 views
0 votes
1 answer

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

Oct 24, 2022 in Others by narikkadan
• 63,680 points
5,777 views
0 votes
1 answer

Finding the minimum values from different columns according to the criteria and multiplying by another column

We must use SUBTOTAL and OFFSET in ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,020 points
505 views