Trending questions in Edureka Community

0 votes
1 answer

Excel - How do I make rows that contain row headers into two columns

You can use this formula: =LET(values,B1:E2, headers,MAP(values,LAMBDA(v,INDEX(A1:A2,ROW(v)))), HSTACK(TOCOL(headers),TOCOL(values))) Via MAP the row headers ...READ MORE

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

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

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

Excel SUM function is not working (shows 0), but using Addition (+) works

The values in A1 and A2 are ...READ MORE

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

How to expend the code to transfer data from one spreadsheet to another based on multiple criteria

 The progress bar is unnecessary. Option Explicit Sub VTest2() ...READ MORE

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

How can I allow a user to change a cell in excel only under particular conditions?

Copy the next event code in the ...READ MORE

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

Vanilla JavaScript equivalent of jQuery's $.ready() - how to call a function when the page/DOM is ready for it

Use Internet Explorer 9 or later if you're using VANILLA pure JavaScript without jQuery. document.addEventListener("DOMContentLoaded", function(event) { // ...READ MORE

Nov 8, 2022 in Java by Damonlang
 • 700 points • 5,374 views
0 votes
1 answer

How to get the total of every monday to saturday or tuesday to sunday in a month dynamically

Try this: Option Explicit Sub demo() ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 86,360 points • 1,826 views
0 votes
0 answers

How do I switch my career from QA tester to DevOps?

How can I switch my career from ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 598 views
0 votes
0 answers

Can I able to switch my career from QA tester to DevOps?

Is it possible to switch my career ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 596 views
0 votes
1 answer

VBA Change Cell colors based on value, and it can deal with single cell and multiple cells changes

Before looping through all of the cells ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 2,169 views
0 votes
0 answers

Is it a good choice to go for DevOps from a system admin? What are the basic tools one should know?

Is shifting from S0ystem Admin role to ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 594 views
0 votes
0 answers

How can I become a DevOps Engineer from Tester?

Could someone tell me how to become ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5, 2025 • 592 views
0 votes
0 answers

What is the work of devops engineer?

Could you please explain the role of ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
 • 12,710 points • 1,147 views
0 votes
0 answers

Is DevOps and System Administrator the same?

Is DevOps and System Administrator both  roles ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 589 views
0 votes
0 answers

What are the different job roles one can apply by doing DevOps course?

What are the various job roles one ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 583 views
0 votes
1 answer

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 16,691 views
0 votes
1 answer

How to multi level sort an array in excel, using formulas? I am aware about the way, using SORT button on DATA tab

Use SORTBY, e.g. =SORTBY(A2:B5,A2:A5,1,B2:B5,1) Or simply&nb ...READ MORE

Jan 22, 2023 in Others by narikkadan
 • 86,360 points • 2,111 views
0 votes
0 answers

Is DevOps a suitable profession for System Admins?

Is DevOps a suitable field for System ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 579 views
0 votes
1 answer

Excel links keep crashing

When the links in the master sheet ...READ MORE

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

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

I saw the problem in the line ...READ MORE

Sep 10, 2022 in Database by narikkadan
 • 86,360 points • 7,942 views
0 votes
0 answers

What are the job opportunities for a devops engineer?

What job roles are provided to a ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 13,800 points
edited Mar 5, 2025 • 576 views
0 votes
1 answer

Insert multiple columns to the right in sequential order

Duplicate Columns Why these complications? Flexibility. You don't have ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,542 views
0 votes
1 answer

Excel VBA: Trying to read all files in folder based on cell input and output to another cell

Your array has no capacity for data ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 86,360 points • 2,015 views
0 votes
1 answer

Formula to count if a text is written in a cell

Use SCAN, like this: =ArrayFormula(IF(A1:A10="",,SCAN(-1,A1:A10,LA ...READ MORE

Feb 4, 2023 in Others by narikkadan
 • 86,360 points • 1,539 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 86,360 points • 5,819 views
0 votes
0 answers

How do I switch to DevOps from Automation Testing?

Could someone tell me how to switch ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5, 2025 • 566 views
0 votes
1 answer

Changing code to adjust number of charts on each powerpoint slide VBA

Try this: Option Explicit Sub CopyChartsToPowerPoint() ...READ MORE

Jan 23, 2023 in Others by narikkadan
 • 86,360 points • 2,051 views
0 votes
0 answers

How do I shift my career from production support analyst to a DevOps Engineer?

How can I shift my career from ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5, 2025 • 562 views
0 votes
1 answer

Get instances of rows in excel for a particular group

You can use the COUNTIF function with ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 1,615 views
0 votes
1 answer

Datedif issue - convert number of days to "--Years--Months--Days" format

Try, =DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"Y") & " Years, " & DATEDIF(0,DATEDIF(B2,C2,"D")*0.75,"YM") ...READ MORE

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

Unable to load 'minutes' correctly from CSV into in Power Query / Pivot

Try this: #"Added Custom" = Table.AddColumn(#"PriorStepNameHere", "Hour", each ...READ MORE

Feb 3, 2023 in Others by narikkadan
 • 86,360 points • 1,570 views
0 votes
0 answers

Passing azure secret variables to pytest in pipeline?

We are using Azure Pipeline to run Python integration tests.  These tests make use of a database, and the login information is saved in an Azure variable group that also contains secret variables.  The integration tests are started in this section of the yaml file: jobs: - job: IntegrationTests variables: ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 1,411 views
0 votes
1 answer

Extracting specific columns from a data frame

Yes, there is a more efficient method ...READ MORE

Jun 22, 2023 in Data Analytics by anonymous
 • 1,420 points • 3,119 views
0 votes
1 answer

Divide a range of values for each unique value

With the next available row as the ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 86,360 points • 1,603 views
0 votes
0 answers

How can a Linux System Administrator switch to a DevOps profile/job?

Can a Linux System Admin switch to ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5, 2025 • 550 views
0 votes
1 answer

How can this code be modified to increase the number of months instead of days?

You have to use dateadd. For i = 1 ...READ MORE

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

Google cloud: How to list all service-accounts from all Projects in GCP

It's been noted by the commenters that ...READ MORE

Nov 10, 2022 in GCP by Tejashwini
 • 5,380 points • 5,236 views
0 votes
0 answers

Can I upskill my career from Production Support Analyst to DevOps Engineer?

Is it possible to upskill my career ...READ MORE

Feb 27, 2023 in DevOps & Agile by Edureka
 • 12,710 points
edited Mar 5, 2025 • 549 views
0 votes
1 answer

Microsoft Open XML Read Excel file using SAX method row by row and finding cell data

I faced a comparable challenge. A bespoke ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 86,360 points • 2,773 views
0 votes
0 answers

Do DevOps engineers write code?

Can anyone tell me whether coding is ...READ MORE

Feb 15, 2023 in DevOps & Agile by Edureka
 • 13,800 points • 1,064 views
0 votes
1 answer

Automatically adding the date/time to a cell when another cell is updated AND clearing it when this cell is empty

You are looking for an IsEmpty check in your ...READ MORE

Jan 26, 2023 in Others by narikkadan
 • 86,360 points • 1,896 views
0 votes
0 answers

Can I apply Slicer value to Summarize function

Hello, I have a Table called work program ...READ MORE

Feb 26, 2023 in Power BI by rajkumar
edited Mar 5, 2025 • 591 views
0 votes
1 answer

How get permission for camera in android.(Specifically Marshmallow)?

To begin with, confirm that the user ...READ MORE

Nov 8, 2022 in Android by Edureka
 • 13,800 points • 5,306 views
0 votes
0 answers

Java snapstart is not available in AWS Lambda

I have started to write Java Lambdas ...READ MORE

Jan 3, 2023 in AWS by Tejashwini
 • 5,380 points • 2,042 views
0 votes
1 answer

Selecting a value of a table in Excel

Use this formula: =LET(step1,FILTER(A1:D6,A1:D1=B11), INDEX(D1:D6, ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 86,360 points • 1,366 views
0 votes
0 answers

How to define a circle shape in an Android XML drawable file?

I'm having some trouble locating the Android ...READ MORE

Nov 22, 2022 in Android by Edureka
 • 12,710 points • 4,646 views
0 votes
1 answer

Find value in column where running total is equal to a certain percentage

VBA bubble sort - no changes to ...READ MORE

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

PMT function in Javascript

Try the following settings to better understand ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 3,777 views
0 votes
0 answers

Related to jar files

: Unable to access jarfile consent-giver-api-0.1-SNAPSHOT.jar READ MORE

Feb 23, 2023 in Java by Humera
edited Mar 5, 2025 • 682 views
0 votes
0 answers

Get target group arn from aws cli

I'm attempting to obtain the arn of a target group whose name contains the word "test" or the value assigned to "value," but I'm having trouble because I keep getting this problem. value=test aws elbv2 describe-target-groups --query "TargetGroups[?starts_with(TargetGroupName, '${value}') == ...READ MORE

Jan 24, 2023 in AWS by Tejashwini
 • 5,380 points • 1,980 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.