Trending questions in Edureka Community

0 votes
1 answer

How to create page borders using Apache POI in excel files with Java?

Microsoft Excel cannot do this. Libreoffice Calc ...READ MORE

Dec 13, 2022 in Others by narikkadan
• 86,360 points
2,010 views
0 votes
1 answer

Filter sumproduct formula based on array

Use ISERROR(MATCH()): =SUMPRODUCT(--(ISERROR(MATCH(Sales[Area];Exceptions[Area];0)));Sales[Quantity];Sales[Price per unit]) --(ISERROR(MATCH(Sales[Area];Exceptions[Area];0))) will return 1 if the ...READ MORE

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

Which aws storage service assists s3 with transferring data

I had this question about transferring data. ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 422 views
0 votes
0 answers

AWS IAM role creation is failing

I have a DynamoDB table created in ...READ MORE

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

edited Mar 4, 2025 431 views
0 votes
0 answers

AWS Cognito that triggers Lambda function and sends me a notification when a new user signs up using SNS

Implementing an AWS Lambda function that sends ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 407 views
0 votes
0 answers

When choosing an aws region which factors should you consider

I have this question. So I setup ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 420 views
0 votes
0 answers

How to do aws certification

I am getting started with learning about ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 414 views
0 votes
0 answers

Which aws certification is in demand

I am always hearing about AWS jobs ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 410 views
0 votes
1 answer

Excel-How can I get the address of a cell instead of a value?

There are various difficulties in this. Which ...READ MORE

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

When choosing an aws region which factors should you consider

Is it mandatory to select location close ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 392 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

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

Python - TypeError: 'int' object is not iterable

Here's my code: import math print("Hey, lets solve Task ...READ MORE

Dec 21, 2022 in Python by erzan
• 630 points
1,665 views
0 votes
1 answer

how to learn devops from scratch?

The road to DevOps is a quite ...READ MORE

Dec 21, 2022 in DevOps & Agile by Edureka
• 12,730 points
1,633 views
0 votes
1 answer

Excel grade formula

Since you said it was just for ...READ MORE

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

Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),$B$2)-MAX(DATE(C ...READ MORE

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

AWS CLI step-functions to get failed executions

How to write a query using AWS ...READ MORE

Dec 20, 2022 in AWS by Tejashwini
• 5,380 points
1,693 views
0 votes
1 answer

Why percentage calculation in excel gives me incorrect numbers

Please be specific with your query. Do ...READ MORE

Dec 11, 2022 in Others by narikkadan
• 86,360 points
2,060 views
0 votes
1 answer

How to sum column until current row?

Use the Header as your starting point: =SUM(Table1[[#Headers],[Num ...READ MORE

Dec 19, 2022 in Others by narikkadan
• 86,360 points
1,677 views
0 votes
1 answer

How to draw wedge shape with outline in Excel VBA?

According to https://learn.microsoft.com/en-us/office/vba/api/excel.adjustments: Because each adjustable shape has a ...READ MORE

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

How to install aws cli on linux

Hi guys. I am running a ubuntu ...READ MORE

Jan 19, 2023 in AWS by Lakhbir
• 100 points

edited Mar 4, 2025 390 views
0 votes
0 answers

SQL - group by column, count into a single row

I'm trying take the result from a group ...READ MORE

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

edited Mar 4, 2025 432 views
0 votes
1 answer

Activating a Specific Cell in Excel Using VBA Results to Error 400

I think you trying to select cells(4, ...READ MORE

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

Terraform script

Created an EC2 instance using terraform,now I ...READ MORE

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

edited Mar 4, 2025 385 views
0 votes
1 answer

Unhide all Hidden Excel Columns Without Individual Iteration?

I discovered that the best way to ...READ MORE

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

How to extract information about remote linux servers using ansible?

It is important to gather data from ...READ MORE

Dec 15, 2022 in Ansible by Edureka
• 12,730 points
1,905 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

Sep 25, 2022 in Others by narikkadan
• 86,360 points
5,383 views
0 votes
0 answers

AWS Lambda read from SQS without concurrency

My requirements are as follows. Every two hours, ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 5,380 points
1,064 views
0 votes
0 answers

How to filter data from a MySQL Database Table with PHP

I'm attempting to code a search box ...READ MORE

Jul 22, 2022 in PHP by narikkadan
• 86,360 points
8,140 views
0 votes
0 answers

Stop all ECS Cluster tasks with AWS CLI

Self answers: How to quickly pass more ...READ MORE

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

edited Mar 4, 2025 396 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

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

How to give RDS instance permission to invoke lambda from CFT or SAM template?

Below is what I wrote in my ...READ MORE

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

edited Mar 4, 2025 392 views
0 votes
1 answer

PHPExcel generated excel file not auto-calculating formula

By recalculating on the server side, it ...READ MORE

Nov 25, 2022 in Others by narikkadan
• 86,360 points
2,702 views
0 votes
1 answer

How to avoid using Select in Excel VBA

Every time you record macros and reuse ...READ MORE

Dec 25, 2022 in Others by narikkadan
• 86,360 points
1,405 views
0 votes
1 answer

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

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

Excel there was a problem sending the command to the program

Solution: You go to Regedit -> HKEY_CLASSES_ROOT\Excel.Sheet.12\Shell\Open : change ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 86,360 points
1,489 views
+1 vote
1 answer

master -> master (non-fast-forward) error: failed to push some refs to 'git@github.com:abc70/new.git'

git pull < branch> <branch name > ctrl+x git ...READ MORE

Mar 21, 2023 in Git & GitHub by anonymous

edited Mar 5, 2025 21,998 views
0 votes
1 answer

How to trigger a file download when clicking an HTML button or JavaScript

You can trigger a download with the ...READ MORE

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

Can someone explain what DevOps is?

Although it is much more than hype, ...READ MORE

Dec 21, 2022 in Other DevOps Questions by Edureka
• 12,730 points
1,566 views
0 votes
0 answers

How can I restrict IP addresses dynamically and release them after 24hrs for AWS s3?

I want to block the IP address ...READ MORE

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

edited Mar 4, 2025 378 views
0 votes
0 answers

In AWS SQS, the "Start DLQ Redrive" button is disabled

I have a Queue set up with ...READ MORE

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

edited Mar 4, 2025 544 views
0 votes
1 answer

Remote Desktop connect to Ubuntu in GCP

The instructions below can be used to ...READ MORE

Nov 4, 2022 in GCP by Tejashwini
• 5,380 points
3,597 views
0 votes
1 answer

Excel Formula/Function to Subtract randomly

The first number we use: =RANDBETWEEN(1,A1) Then the second: =RANDBETWEEN(1,A1-B1) Then ...READ MORE

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

Transfer Data from AWS Time Stream to DynamoDB

I deal with two databases in the ...READ MORE

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

edited Mar 4, 2025 371 views
0 votes
1 answer

Xcode 13.2.1 error when running on phone with iOS 15.4.1

Check /Applications/Xcode.app/Contents/Developer/Platforms/iPhoneOS.platform/DeviceSupport/ for directory name 15.4 (your ...READ MORE

Dec 15, 2022 in Mobile Development by gaurav
• 23,580 points
2,117 views
0 votes
0 answers

Use camera flashlight in Android

I'm trying to use the cameras LED ...READ MORE

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

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

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

How to display employee names starting with a and then b in sql

I want to display the names of ...READ MORE

Aug 12, 2022 in Database by Kithuzzz
• 38,000 points
1,888 views
0 votes
1 answer

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

Feb 11, 2022 in Others by Rahul
• 9,690 points
15,043 views
0 votes
1 answer

How to add Indian Rupee Currency symbol in Google Spreadsheet

To apply a custom currency format to ...READ MORE

Nov 8, 2022 in Others by gaurav
• 23,580 points
3,399 views