Trending questions in Edureka Community

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
• 2,387 views
0 votes
1 answer

Python erroring

Amend the spreadsheet file path from: 'C:\Technical\AutomationScri ...READ MORE

Feb 10, 2023 in Others by narikkadan
• 86,360 points
• 2,632 views
0 votes
1 answer

Reference Excel sheet number in an external workbook

Try this: Function SheetByCodeName(wb As Workbook, cn As ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,000 points
• 1,529 views
0 votes
1 answer

VBA Project creating a subroutine for activcell

You have to increase ActiveCell's value by ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 86,360 points
• 2,668 views
0 votes
1 answer

Excel VBA Scheduled message pop up box reminder

What exactly does W11 contain? In Excel, ...READ MORE

Feb 3, 2023 in Others by narikkadan
• 86,360 points
• 2,923 views
0 votes
1 answer
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

Feb 6, 2023 in Others by narikkadan
• 86,360 points
• 2,788 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
• 86,360 points
• 2,646 views
0 votes
0 answers

Does the string "php?id=1" within a http GET request mean there is necesseraly an sql request to a back-end database?

You can use Google dorks like "inurl:.php?id=" ...READ MORE

Aug 6, 2022 in PHP by Kithuzzz
• 38,000 points
• 10,694 views
0 votes
0 answers

Create Terraform Cloudwatch Dashboards dynamically

Overview Currently, dashboards are being deployed via Terraform ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
• 5,380 points
• 2,872 views
0 votes
1 answer

Extending auto-generated Amplify Datastore classes with factory constructors

it seems like the issue is that ...READ MORE

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

Trigger a lambda function after a rest api is accessed

To trigger a Lambda function after a ...READ MORE

Feb 16, 2023 in AWS by anonymous
• 2,346 views
0 votes
1 answer

How can I stop my vba code from giving me an error 424?

Object Variables in Loops The main issue was ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 86,360 points
• 2,613 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

Nov 17, 2022 in Others by narikkadan
• 86,360 points
• 6,249 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,000 points
• 2,134 views
0 votes
1 answer

Excel VBA function that cross references two data sets to come up with one solution

Solution using dictionary to count Public Sub citizens() ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 86,360 points
• 2,306 views
0 votes
1 answer

How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
• 2,435 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

Oct 15, 2018 in Power BI by Hannah
• 18,520 points
• 38,191 views
0 votes
0 answers

ErrorDocument 404 /404.php is not working in .htaccess file in PHP

This is the Content of my .htaccess file is: ErrorDocument ...READ MORE

Jun 21, 2022 in PHP by narikkadan
• 86,360 points
• 2,565 views
0 votes
0 answers

Using XML with REST API through Azure Datafactory V2

I need to use a REST API ...READ MORE

Feb 15, 2023 in Azure by Damonlang
• 1,230 points
• 2,354 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,000 points
• 1,996 views
0 votes
1 answer

Ignore empty filter criteria in SUMPRODUCT formula

=SUMPRODUCT(($C$2:$C$7)*(IF(E1="",1,($A$2:$A$7=E1))*(IF(E2="",1,$B$2:$B$7=E2)))) Replaces the condition with 1 (all values) in case E1 and/or E2 is ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
• 2,386 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,000 points
• 1,992 views
0 votes
0 answers

Axios, is it slower to auto catch error responses (such as 404)?

Just out of curiosity, the default setting ...READ MORE

Feb 14, 2023 in AWS by Ashwini
• 5,440 points
• 2,318 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
• 86,360 points
• 2,760 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,000 points
• 2,501 views
0 votes
1 answer

Excel Desktop - Office.context.document.settings.get() didn't working

You need to call the saveAsync method of the Office.Settings interface ...READ MORE

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

VBA Excel: Write timestamp to cell on change of another cell

Your request is a little vague, and ...READ MORE

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

How can I enable jenkins to execute the shell commands as sudo or root?

Hey,  Create a freestyle project on Jenkins Use the ...READ MORE

Oct 23, 2020 in Jenkins by Hana
• 38,768 views
0 votes
1 answer

Excel VBA creating a new Outlook appointment results in a cancelled appointment

Because an inappropriate sender will be used, ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
• 2,335 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
• 86,360 points
• 2,245 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Print Copies of Single Worksheet With Increment Option ...READ MORE

Jan 22, 2023 in Others by narikkadan
• 86,360 points
• 3,324 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
• 13,407 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
• 2,335 views
+1 vote
1 answer

How to use .status folder for WhatsApp status saver app in android 11 scoped storage?

Request the user to give permission to ...READ MORE

Nov 8, 2022 in Android by Edureka
• 13,800 points
• 6,510 views
0 votes
1 answer

outputting a coloured excel file, python

If you already have an Excel workbook, ...READ MORE

Mar 17, 2023 in Others by Kithuzzz
• 38,000 points
• 1,386 views
0 votes
0 answers

runs on f8 but not on f5

Sub copypartdatatest()     Dim ctr, tdt, lr, lr1, lr2, ...READ MORE

Mar 25, 2023 in Others by Madhusudan

edited Mar 5, 2025 • 638 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
• 2,221 views
0 votes
1 answer

Calling AWS ELB public DNS from AWS EC2 client. How much do I get charged?

If you are calling an AWS Elastic ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
• 2,177 views
+2 votes
2 answers

ModuleNotFoundError: No module named 'pyttsx3

Hi@akhtar, To avoid this error you have to ...READ MORE

Apr 24, 2020 in Python by MD
• 95,460 points
• 37,392 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
• 86,360 points
• 2,204 views
0 votes
1 answer

How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI?

By making a new measure that didn't ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,000 points
• 2,290 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
• 86,360 points
• 1,855 views
0 votes
1 answer

Power Query M Lookup on Same table with Filtering

In power query, merge the table on ...READ MORE

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

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 86,360 points
• 4,354 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 86,360 points
• 3,185 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,000 points
• 2,150 views
0 votes
1 answer

Android - Set text to TextView

After discovering the views, you set the ...READ MORE

Nov 10, 2022 in Android by Edureka
• 12,710 points
• 6,385 views
0 votes
0 answers

Retrieve or store results of Gremlin queries within AWS Neptune ML, in IPython Notebook

I need to use Gremlin in a ...READ MORE

Dec 15, 2022 in AWS by Tejashwini
• 5,380 points
• 2,013 views
0 votes
1 answer

Concatenate or TextJoin Same Cell Multiple Times based on Value in another Cell?

Use the REPT function: =REPT("ABC",4) => ABCABCABCABC ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 86,360 points
• 2,091 views