Trending questions in Edureka Community

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,078 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,430 points • 2,104 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,608 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,763 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,164 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,363 views
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,060 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,611 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 • 1,873 views
0 votes
1 answer

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 86,360 points • 7,273 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,504 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,117 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,683 views
0 votes
0 answers

iOS Custom Notification Sound (UNNotificationSound) doesn't play when iPhone is locked

I edit the notification before showing it ...READ MORE

Sep 22, 2022 in IOS by Soham
 • 9,730 points • 8,270 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 • 5,740 views
0 votes
1 answer

How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE

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

What do * and ** before a variable name mean in a function signature?

What do the * and ** mean in this code? def functionA(self, ...READ MORE

Mar 20, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 638 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,136 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,156 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,002 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,465 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 • 1,827 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,076 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,010 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,681 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,195 views
0 votes
1 answer

How to set my Activity as main activity in android?

The "intent-filter" in "AndroidManifest.xml" allows you to ...READ MORE

Nov 8, 2022 in Android by Edureka
 • 13,730 points • 6,297 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,480 views
0 votes
0 answers

How to delete my edureka account?

I no longer want use edureka. So, ...READ MORE

Mar 21, 2023 in Others by Edureka
edited Mar 5, 2025 • 558 views
0 votes
0 answers

how to submit the assignments which is in eclipse to edureka assignment page

I have to submit my assignments in ...READ MORE

Mar 20, 2023 in Java by Bhuvana
edited Mar 5, 2025 • 599 views
0 votes
0 answers

Selection Sort in Python

This may seem like a simple question ...READ MORE

Mar 20, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 595 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 • 1,931 views
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,388 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,614 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,560 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,000 points • 1,921 views
0 votes
1 answer

Where are the Microsoft Visual C++ 2015-2022 Redistributable (x64) packages installed?

They are, in my opinion, at their best. C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Redist\MSVC It's worth noting ...READ MORE

Jun 15, 2022 in C++ by Damon
 • 4,960 points • 12,569 views
0 votes
1 answer

To automatically print in excel but nothing happens

This is a revised version of your ...READ MORE

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

Correlation and heatmap for dataset having numerical and categorical variables

I want to measure the correlation and ...READ MORE

Mar 1, 2023 in Data Science by Chitrolekha
edited Mar 5, 2025 • 1,415 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,212 views
0 votes
0 answers

What can you use generator functions for?

I'm starting to learn Python and I've ...READ MORE

Mar 20, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 574 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
 • 86,360 points • 1,602 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 • 2,938 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 • 1,905 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,026 views
0 votes
0 answers

square root of a number greater than 10^2000 in Python 3

I'd like to calculate the square root ...READ MORE

Mar 20, 2023 in Python by anonymous
 • 990 points
edited Mar 5, 2025 • 562 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,011 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,090 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 • 1,832 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.