Trending questions in Edureka Community

0 votes
1 answer

Python vs Cpython

So what is CPython? CPython is the original Python implementation. ...READ MORE

Jan 4, 2023 in Python by Elton
• 400 points
877 views
0 votes
1 answer

Opening large Workbooks in excel

Here is a code I tried to ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 63,600 points
747 views
0 votes
1 answer

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 63,600 points
607 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
• 63,600 points
5,766 views
0 votes
1 answer

How many sheets are there in Excel Workbook by default?

It is 3. As stated officially by ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 63,600 points
734 views
0 votes
1 answer

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 63,600 points
469 views
0 votes
1 answer

Unprotect an Excel file programmatically

Try this. It worked for me.  def Remove_password_xlsx(filename, ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 63,600 points
1,890 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 63,600 points
463 views
0 votes
1 answer

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 63,600 points
587 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

Jan 7, 2023 in Others by narikkadan
• 63,600 points
715 views
0 votes
1 answer

CSS calc width and height values

Yes, there are CSS variables named vh ...READ MORE

Aug 4, 2022 in CSS by Tanishqa
• 1,170 points
7,451 views
0 votes
0 answers

AWS entry level opportunities

I noticed that the job market misses ...READ MORE

Jan 21, 2023 in Career Counselling by anonymous

edited 5 days ago 123 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 63,600 points
668 views
0 votes
1 answer

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

Jan 13, 2023 in Others by narikkadan
• 63,600 points
448 views
0 votes
1 answer

Vanilla JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it

Use Internet Explorer 9 or later if you're using VANILLA pure JavaScript without jQuery. document.addEventListener("DOMContentLoaded", function(event) { // ...READ MORE

Nov 8, 2022 in Java by Damonlang
• 700 points
3,295 views
0 votes
1 answer

What's the difference between VARCHAR and CHAR?

CHAR is a fixed-length character data type, ...READ MORE

Apr 26, 2023 in Database by Kanav Chopra

edited 4 days ago 845 views
0 votes
1 answer

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Excel will automatically make assumptions about the ...READ MORE

Jan 8, 2023 in Others by narikkadan
• 63,600 points
652 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

Jan 9, 2023 in Others by narikkadan
• 63,600 points
606 views
0 votes
0 answers

What is "main" branch in context of Azure DevOps pipeline caching?

I'm attempting to employ the Azure DevOps ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
883 views
0 votes
0 answers

Get the name of a dynamo table created with AWS CDK

Using the example from here. I can create ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 3,820 points
828 views
0 votes
0 answers

AWS future scope

Hi guys. Given the current market condition ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 12 views
0 votes
0 answers

Why is aws so popular

So I am just curious to know. ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 12 views
0 votes
0 answers

Why am i being charged for amazon web services

So I created my free account on ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 13 views
0 votes
1 answer

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 63,600 points
555 views
0 votes
0 answers

How much does aws cost

Hi guys. So I had this question ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 13 views
0 votes
1 answer

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

Jan 9, 2023 in Others by narikkadan
• 63,600 points
596 views
0 votes
0 answers

What companies use aws

Hi guys. So I was actually trying ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 12 views
0 votes
0 answers

How much of the internet is on aws

Hi. I was curious to know this. ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 12 views
0 votes
0 answers

How to start with aws

Hi. So I am getting started with ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 6 views
0 votes
0 answers

Why choose aws

The question is that simple. Why should ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 6 views
0 votes
0 answers

How to start learning aws

Hi. I want to know how I ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 7 views
0 votes
0 answers

How much does s3 cost

Hi. I have a small website getting ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 5 views
0 votes
0 answers

How to use aws for free

I am new to cloud computing and ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 6 views
0 votes
0 answers

How much does aws cost per month

Let's say I wanna host my website ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 7 views
0 votes
0 answers

Why should you measure amazon ec2 instance performance

So I read about this thing that ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 7 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

Oct 28, 2022 in Others by narikkadan
• 63,600 points
3,749 views
0 votes
0 answers

What are amazon web services

I know it is an obvious question ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 7 views
0 votes
0 answers

When was aws founded

When was the AWS services founded? I ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 6 views
0 votes
0 answers

Why aws is better

As the title states, my question is ...READ MORE

Jan 23, 2023 in AWS by Lakhbir
• 100 points

edited 5 days ago 6 views
0 votes
0 answers

Preventing an auto-terminated spot instances from restarting

Let's say I receive a size 1 ...READ MORE

Jan 23, 2023 in AWS by Tejashwini
• 3,820 points

edited 5 days ago 8 views
0 votes
1 answer

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

Jan 6, 2023 in Others by narikkadan
• 63,600 points
719 views
0 votes
0 answers

Deploy Deno to AWS Lightsail

Is there any alternative to using the ...READ MORE

Jan 23, 2023 in AWS by Tejashwini
• 3,820 points

edited 5 days ago 7 views
0 votes
1 answer

How to paste an Excel chart into PowerPoint placeholder using Python?

Very near indeed! Copy and Paste are ...READ MORE

Oct 7, 2022 in Others by narikkadan
• 63,600 points
4,645 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
1,055 views
0 votes
1 answer

What is the data type of (1) in python?

Typecasting is the process of converting one ...READ MORE

Jan 4, 2023 in Python by Elton
• 400 points
795 views
0 votes
1 answer

How to convert excel to PDF using Python

Specify your whole output path instead of ...READ MORE

Nov 10, 2022 in Others by narikkadan
• 63,600 points
3,170 views
0 votes
1 answer

Laravel Excel import using Maatwebsite Excel package with additional columns from View

How to fix: I know you're fed ...READ MORE

Apr 1, 2022 in Database by gaurav
• 23,260 points
12,822 views
0 votes
0 answers

How purple 200/500/700 define in the color.xml of a new Android Project?

A new Android project provides a set ...READ MORE

Nov 23, 2022 in Android by Ashwini
• 5,430 points
2,621 views
0 votes
1 answer

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

Jan 12, 2023 in Others by narikkadan
• 63,600 points
437 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 63,600 points
520 views