Trending questions in Edureka Community

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,715 views
0 votes
1 answer

How to return a result from a VBA function

You must associate the value with the ...READ MORE

Nov 4, 2022 in Others by narikkadan
• 86,360 points
4,004 views
0 votes
1 answer

Adding column to Excel using Apache POI

The quickest way to add a column ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 86,360 points
3,352 views
0 votes
1 answer

HTML and CSS: What do the <ul> and <li> tags stand for?

The term ul stands for unordered list. ...READ MORE

Aug 4, 2022 in CSS by Tanishqa
• 1,370 points
7,967 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
1,184 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
1,353 views
0 votes
1 answer

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

Oct 16, 2022 in Others by narikkadan
• 86,360 points
4,811 views
0 votes
0 answers

Can we automate React app using selenium?

Can we automate React app using selenium? READ MORE

Jan 19, 2023 in Selenium by Sukanya

edited Mar 4, 2025 723 views
0 votes
1 answer

how devops works with aws?

The two most potent technologies—AWS and DevOps—can ...READ MORE

Jan 3, 2023 in DevOps on Cloud by Edureka
• 12,730 points
1,392 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
957 views
0 votes
1 answer

Is there a combination of "LIKE" and "IN" in SQL?

There is no LIKE & IN combination ...READ MORE

Sep 18, 2022 in Database by narikkadan
• 86,360 points
6,031 views
0 votes
1 answer

Is it possible to run .APK/Android apps on iPad/iPhone devices?

It is not possible to run Android ...READ MORE

Sep 20, 2022 in IOS by Aditya
• 7,680 points
5,901 views
0 votes
2 answers

How to change the default Jenkins port in Windows?

Hi@akhtar, Yes, you can change Jenkins port no. ...READ MORE

Jun 3, 2020 in Jenkins by MD
• 95,460 points
30,544 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
1,118 views
0 votes
0 answers

Facebook iOS 9 SDK login redirects to mbasic.facebook.com on Safari

I'm using the iOS 9 Facebook SDK to manage ...READ MORE

Nov 8, 2022 in Mobile Development by gaurav
• 23,580 points
3,000 views
+6 votes
3 answers

"Error: '\U' used without hex digits in character string starting ""C:\U"" when trying to read a csv file in R

Replace all \ with \\. Its trying ...READ MORE

Nov 26, 2018 in Data Analytics by Maverick
• 10,840 points
49,578 views
0 votes
1 answer

Excel Consolidate Data not working - Data does not merge

This is so that letters cannot be ...READ MORE

Nov 17, 2022 in Others by narikkadan
• 86,360 points
3,369 views
0 votes
0 answers

Unauthorized error with git tfs list-remote-branches

I have a repo in Azure Devops ...READ MORE

Jan 5, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
1,307 views
0 votes
1 answer

Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

Oct 31, 2022 in Others by narikkadan
• 86,360 points
4,131 views
0 votes
1 answer

Mat-icon doesn't export in excel sheet?

Icons have their own coding you can ...READ MORE

Dec 15, 2022 in Others by narikkadan
• 86,360 points
2,184 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
1,320 views
0 votes
1 answer

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

Jan 5, 2023 in Others by narikkadan
• 86,360 points
1,267 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
921 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
1,124 views
0 votes
1 answer

How do I merge multiple excel files to a single excel file

You copy a worksheet from before each ...READ MORE

Dec 24, 2022 in Others by narikkadan
• 86,360 points
1,769 views
0 votes
0 answers

TypeError: not all arguments converted during string formatting python

The program is supposed to take in ...READ MORE

Dec 22, 2022 in Python by erzan
• 630 points
1,888 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
903 views
0 votes
0 answers

I wrote this function but it returned only the false and not the true but I have "PROOF" in the ABV (3) FIELD

IF(BEER[ABV (3)]="PROOF",CONVERT(DIVIDE(BEER[Column TRY],2,0),STRING),BEER[ABV (3)]). Please what is ...READ MORE

Jan 26, 2023 in Power BI by Frederick

edited Mar 4, 2025 383 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
1,024 views
0 votes
0 answers

Origin of the C# language name

Programmer in C and C++, currently attempting ...READ MORE

Sep 20, 2022 in C# by Edureka
• 13,740 points
1,279 views
0 votes
0 answers

Connect to RDS through VPC Peering

I'm attempting to establish a VPC Peering ...READ MORE

Jan 18, 2023 in AWS by Tejashwini
• 5,380 points

edited Mar 4, 2025 696 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, 2025 471 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

Jan 9, 2023 in Others by narikkadan
• 86,360 points
1,050 views
+1 vote
0 answers

How to keep Docker container running after starting services?

Although I've read many instructions that appear ...READ MORE

Dec 13, 2022 in Docker by Edureka
• 13,740 points
2,189 views
0 votes
0 answers

Will AWS S3 reject a read during an object being updated?

According to the S3 documentation, a PUT ...READ MORE

Jan 18, 2023 in AWS by Tejashwini
• 5,380 points

edited Mar 4, 2025 665 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, 2025 447 views
0 votes
1 answer

ASP.NET generated excel file has different format than extension

You must include the xlsx file extension. The ...READ MORE

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

How to exclude weekend (Sunday only) to DATEDIFF in Tableau?

To exclude Sundays from the DATEDIFF calculation ...READ MORE

Jul 3, 2023 in Tableau by anonymous
• 1,420 points
3,228 views
0 votes
1 answer

Highlight active row/column in Excel without using VBA?

Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE

Oct 27, 2022 in Others by narikkadan
• 86,360 points
4,228 views
0 votes
1 answer

MS Excel TRUE/FALSE Formula Not Returning Expected Result

The reason for this is that the 'words' ...READ MORE

Nov 8, 2022 in Others by gaurav
• 23,580 points
3,705 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, 2025 440 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
1,023 views
0 votes
0 answers

Using podman instead of docker for the Docker@2 task in Azure DevOps

Our build agent is running Podman 3.4.2, and each terminal session has a global alias that just replaces docker with podman, thus the command docker —version returns podman version 3.4.2 as a consequence. The purpose is to employ podman in an Azure DevOps pipeline for the Docker@2 task: steps: - task: Docker@2 displayName: Build and ...READ MORE

Dec 15, 2022 in DevOps on Cloud by Nicholas
• 7,760 points
2,145 views
0 votes
1 answer

Trying to apply Solver with Macros

The  MaxMinVal was when you wanted to ...READ MORE

Jan 10, 2023 in Others by narikkadan
• 86,360 points
975 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, 2025 433 views
0 votes
1 answer

Excel Formula: Count cells where value is date

Dates in Excel are just formatted numbers, ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 86,360 points
2,272 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, 2025 431 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, 2025 427 views
0 votes
1 answer

Broken external links in Excel : a leading "file:///" scheme appended to paths can't be evaluated in formulas

If not already done, save and close ...READ MORE

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

Excel: Group rows and add minimum and maximum from two different columns within the group

You can accomplish your goal with Power ...READ MORE

Dec 19, 2022 in Others by narikkadan
• 86,360 points
1,880 views