Trending questions in Edureka Community

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

Historical Yahoo Finance API On Fritz Again?

It appears that Yahoo updated its finance ...READ MORE

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

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

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

How to Clear Table Style in Office Scripts?

Excel tables on the web are constantly ...READ MORE

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

editing aws lambda inline with large package size

In the working directory of an AWS ...READ MORE

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

edited Mar 4 165 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 121 views
0 votes
1 answer

what is devops in linux?

Compared to Windows, the Linux operating system ...READ MORE

Jan 3, 2023 in DevOps & Agile by Edureka
• 12,700 points
785 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
780 views
0 votes
1 answer

In excel 365 how to subtract values sequentially but skip empty cells

Try the following formula in C4 and ...READ MORE

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

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

Feb 16, 2022 in Others by Edureka
• 13,690 points
14,634 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 136 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
1,624 views
0 votes
1 answer

Excel Formula Help Conditional Formatting - If A2 =TODAY and B2=Y turn A2 Green. If B2 = N turn A2 RED

Create a conditional format rule on A2 ...READ MORE

Dec 29, 2022 in Others by narikkadan
• 86,360 points
994 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 131 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 131 views
0 votes
0 answers

Build images as part of Jenkins Worker on Kubernetes

I have Jenkins deployed on kubernetes (AWS ...READ MORE

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

edited Mar 4 130 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 126 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 126 views
0 votes
0 answers

How to create "Python Package Download" Azure DevOps Service Connection?

I need to set up an Azure ...READ MORE

Jan 5, 2023 in DevOps on Cloud by Damonlang
• 1,230 points
687 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 121 views
0 votes
1 answer

Excel plot time series frequency with continuous xaxis

Excel has a few oddities that must ...READ MORE

Nov 7, 2022 in Others by narikkadan
• 86,360 points
3,209 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
29,907 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,680 points
694 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

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

SQL query to select dates between two dates

you should put those two dates between ...READ MORE

Nov 7, 2022 in Others by gaurav
• 23,580 points
3,236 views
0 votes
1 answer

Excel formula to convert EST date time into IST date time?

The code: =IF(A1-TIME(10,30,0)<0,ABS(1+A1-TIME(10,30,0)),A1-TIME(10,30,0))  It works if your cell ...READ MORE

Dec 27, 2022 in Others by narikkadan
• 86,360 points
1,041 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,149 views
0 votes
0 answers

Transfer Data from AWS Time Stream to DynamoDB

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

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

edited Mar 4 134 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 17, 2023 in AWS by Tejashwini
• 5,380 points

edited Mar 4 131 views
0 votes
1 answer

Make certain characters in an Excel cell subscript Python

With Xlwings, you may accomplish this by ...READ MORE

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

PHPExcel freeze row and columns

You must be attempting to Freeze both ...READ MORE

Nov 17, 2022 in Others by narikkadan
• 86,360 points
2,708 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,492 views
0 votes
0 answers

Left-, center-, and right-aligned text on the same line

Is it possible to use HTML/CSS to ...READ MORE

Aug 17, 2022 in HTML by Deepak
• 980 points
6,737 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
936 views
0 votes
1 answer

how devops helps in testing?

Everyone is encouraged to add to the ...READ MORE

Jan 3, 2023 in DevOps & Agile by Edureka
• 12,700 points
702 views
0 votes
1 answer

Excel Online Script for Message Boxes

Use "throw" followed by your text to ...READ MORE

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

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML():   Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

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

aws-cdk: pass ENV to NextJS app throught Ec2TaskDefinition

My node.js app needs creds and an ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
• 5,380 points
706 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
703 views
0 votes
0 answers

Append data to a particular column of CSV/Excel File

There are no headers of excel/csv file. ...READ MORE

Jan 14, 2023 in RPA by Abhishek

edited Mar 4 212 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
5,316 views
0 votes
0 answers

How to display and raise warnings in release pipeline for Azure devops?

I'm running a Python script in my ...READ MORE

Dec 13, 2022 in DevOps on Cloud by Nicholas
• 7,760 points
1,581 views
0 votes
1 answer

What is the character code for new line break in excel

Use CHAR(10) and Turn on Wrap Text option. It ...READ MORE

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

Imitate Excel style gradient color effect (red, yellow, green) in gt::data_color()

The similar color palette: c("#63be7b", "#ffeb84", "#f8696b") df %>% ...READ MORE

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

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

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

Merge rows based on value (pandas to excel - xlsxwriter)

I'm attempting to use xlsxwriter to output ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,000 points
3,327 views
0 votes
1 answer

How to use .status folder for WhatsApp status saver app in android 11 scoped storage?

Request the user to give permission to ...READ MORE

Nov 8, 2022 in Android by Edureka
• 13,680 points
3,056 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
3,576 views