Trending questions in Edureka Community

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 • 102 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 • 681 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 • 961 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,875 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,176 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 • 123 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,210 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,015 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 • 115 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,902 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,470 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,591 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,708 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,094 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 • 911 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,710 points • 669 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 • 688 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 • 896 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 • 685 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,654 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 • 192 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,102 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 • 897 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 • 941 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,545 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,533 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 • 162 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,227 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,238 views
0 votes
0 answers

Where to handle authorization and routing for microservices with Application Load Balancer on AWS?

I currently have an ALB that forwards ...READ MORE

Jan 14, 2023 in AWS by Tejashwini
 • 5,380 points
edited Mar 4 • 154 views
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 86,360 points • 2,289 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,248 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,596 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,184 views
0 votes
0 answers

I can't link my MongoDB compass application(local machine) with database in a digital ocean droplet.

I made a droplet in Digital Ocean&nbs ...READ MORE

Jan 2, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points • 661 views
0 votes
0 answers

how to improve devops skills?

What are some of the fundamentals or ...READ MORE

Jan 2, 2023 in DevOps & Agile by Edureka
 • 13,680 points • 579 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,275 views
0 votes
1 answer

DATEDIF Excel - output incorrect

If you want the difference in days, ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 86,360 points • 854 views
0 votes
0 answers

AWS availability zones error in naming error

Any idea why I am getting this ...READ MORE

Jan 14, 2023 in AWS by Tejashwini
 • 5,380 points
edited Mar 4 • 129 views
0 votes
0 answers

AWS StateMachine AccessDeniedException in step: CleanUpOnError

I am getting the following error when ...READ MORE

Jan 14, 2023 in AWS by Tejashwini
 • 5,380 points
edited Mar 4 • 129 views
0 votes
0 answers

if else conditions not working in ejs after I hosted using aws and nginx

if else conditions working fine in the ...READ MORE

Jan 14, 2023 in AWS by Tejashwini
 • 5,380 points
edited Mar 4 • 129 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 • 894 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,519 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 • 813 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 • 2,993 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,052 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,710 points • 1,131 views
0 votes
1 answer

Convert xls to csv without any data changes

Here are the 3 solutions I have ...READ MORE

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

which of the following is not a devops tools?

Which of the following is Not a ...READ MORE

Dec 22, 2022 in DevOps & Agile by Edureka
 • 13,680 points • 1,105 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.