Trending questions in Edureka Community

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
1,945 views
0 votes
1 answer
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,567 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 541 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 538 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,065 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 494 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
1,990 views
0 votes
1 answer

How to get all Stock list company name and symbol of NSE and BSE with free API?

Check the below link for your answer: http://www.barchartondemand. ...READ MORE

Nov 13, 2022 in Others by narikkadan
• 86,360 points
6,002 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
1,985 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 522 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,724 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,185 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 501 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,572 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,835 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,653 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,086 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,521 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,516 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,323 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
1,982 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,442 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,799 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,794 views
0 votes
0 answers

how to know the day (is it Monday, Tuesday or...) of a specific date in Python

I have a pandas dataframe with one ...READ MORE

Mar 20, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 456 views
0 votes
1 answer

SQL Server Convert Varchar to Datetime

Try this: SELECT CONVERT(Datetime, '2011-09-28 18:01:00', 120) -- ...READ MORE

Sep 13, 2022 in Database by narikkadan
• 86,360 points
8,583 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,051 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
1,847 views
0 votes
1 answer

Creating sheets with names in column B and assigning data to each sheet for particular name

after the first occurrence of Set sht = ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 86,360 points
1,947 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
1,816 views
0 votes
1 answer

DMZ kind of network design in the AKS

It sounds like you want to implement ...READ MORE

Feb 17, 2023 in AWS by sarit
• 1,830 points
1,776 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,803 views
0 votes
1 answer

How to compare 2 cells with delimited items in each and output the difference in items?

The following function would do this for ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,506 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,520 views
0 votes
1 answer

How to deploy Airflow to production being agnostic to Cloud providers?

Yes, deploying Airflow using Docker is a ...READ MORE

Feb 17, 2023 in AWS by anonymous
1,767 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,716 views
0 votes
1 answer

Excel Count unique values beetween 2 columns

Try this : • Formula used in cell D3 =LET(x,UNIQUE( ...READ MORE

Feb 23, 2023 in Others by Kithuzzz
• 38,000 points
1,497 views
0 votes
0 answers

Java 11 JDK for Windows 7 32-bit system

I wanted to install Java 11 on ...READ MORE

Apr 21, 2022 in Java by Rahul
• 3,380 points
5,641 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
1,869 views
0 votes
0 answers

How can I get the source code of a Python function?

Suppose I have a Python function as ...READ MORE

Mar 16, 2023 in Python by anonymous
• 990 points

edited Mar 5, 2025 592 views
0 votes
1 answer

Excel Get different permutation combination of the values

This work can be completed utilising dynamic ...READ MORE

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

Conditional format based on external cell value

Use a rule with the formula =$Q6="Yes" and apply ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 86,360 points
1,774 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,201 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,273 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,000 points
1,460 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
• 86,360 points
1,408 views
0 votes
0 answers

Azure Vnet Private IP Ranges

I don't have experience in networking. I'm ...READ MORE

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

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

Jan 20, 2023 in Others by narikkadan
• 86,360 points
2,902 views