Trending questions in Edureka Community

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,179 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 • 160 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 • 115 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 • 155 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,809 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 • 771 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,158 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,196 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 • 767 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 • 129 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,613 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 • 125 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 • 124 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 • 118 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 • 118 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 • 980 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 • 117 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,606 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 • 678 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 • 110 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 • 689 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,891 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,192 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,222 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,924 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,026 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 • 128 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 • 121 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,121 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,480 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,605 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,723 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 • 927 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,679 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 • 687 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 • 915 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 • 699 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 • 695 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,126 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 • 201 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,562 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 • 906 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 • 951 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,548 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,278 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,243 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 • 170 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,622 views
0 votes
0 answers

Publish a pipeline Azure Devops code coverage report

I am trying to publish a detailed ...READ MORE

Dec 20, 2022 in DevOps on Cloud by Damonlang
 • 1,230 points • 1,247 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,304 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.