Trending questions in Edureka Community

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
 • 86,360 points • 756 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
 • 86,360 points • 838 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
 • 86,360 points • 3,383 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
 • 86,360 points • 616 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
 • 86,360 points • 613 views
0 votes
1 answer

Create Drop-Down List Using a Formula (Without Data Validation)

As far as I am aware, it ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 3,455 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
 • 86,360 points • 602 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
 • 86,360 points • 902 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 • 1,046 views
0 votes
1 answer

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 14,773 views
0 votes
1 answer

npm dotenv environment variables not recognized in nodejs module

process.env object that are defined in the ...READ MORE

Jun 10, 2022 in Node-js by Neha
 • 9,020 points • 9,934 views
0 votes
1 answer

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 1,011 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
 • 86,360 points • 743 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 1,397 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 • 955 views
0 votes
1 answer

Excel how to find the default file extension

Make a dict of xlfileformats:extensions and use ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 86,360 points • 912 views
0 votes
0 answers

How to define a circle shape in an Android XML drawable file?

I'm having some trouble locating the Android ...READ MORE

Nov 22, 2022 in Android by Edureka
 • 12,710 points • 2,766 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 1,477 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
 • 86,360 points • 733 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 Mar 4 • 148 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 Mar 4 • 230 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 Mar 4 • 147 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 Mar 4 • 144 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 Mar 4 • 146 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 Mar 4 • 145 views
0 votes
1 answer

Open SAP from Excel VBA

It just means that there is no ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 5,109 views
0 votes
1 answer

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 86,360 points • 5,991 views
0 votes
1 answer

How do I install Java on Mac OSX allowing version switching?

With Homebrew and Jenv: Assumption: You have a ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
 • 220 points • 975 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 Mar 4 • 124 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
 • 5,380 points
edited Mar 4 • 131 views
0 votes
1 answer

Why is `(True, True, True) == True, True, True` not True in Python?

Operator precedence. You're actually checking equality between (True, ...READ MORE

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

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,278 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
 • 86,360 points • 580 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 Mar 4 • 121 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 Mar 4 • 119 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
 • 5,380 points
edited Mar 4 • 124 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
 • 86,360 points • 657 views
0 votes
0 answers

Object cannot be cast from DBNull to other types

I am getting this error and I am ...READ MORE

May 14, 2022 in Others by Kichu
 • 19,040 points • 2,678 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 Mar 4 • 110 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 Mar 4 • 110 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 Mar 4 • 110 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 Mar 4 • 111 views
0 votes
1 answer

How to set selected value of jQuery Select2?

To set selected value of jQuery Select2 ...READ MORE

Aug 5, 2022 in Web Development by rajatha
 • 7,680 points • 7,484 views
0 votes
1 answer

Can you use aws-sdk/util-dynamodb unmarshall in Reactjs?

Yes, you can use the unmarshall method ...READ MORE

Jan 4, 2023 in AWS by Ashwini
 • 5,430 points • 918 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 Mar 4 • 108 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 Mar 4 • 108 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 Mar 4 • 107 views
0 votes
0 answers

Get yesterday's date in bash on Linux, DST-safe

I have a shell script that runs ...READ MORE

Dec 14, 2022 in Linux Administration by erzan
 • 630 points • 1,793 views
0 votes
1 answer

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 733 views
0 votes
1 answer

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

Jan 8, 2023 in Others by narikkadan
 • 86,360 points • 728 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.