Trending questions in Edureka Community

0 votes
1 answer

Modifying CSV files from a local folder-VBA

Solution  You need to fully qualify your Columns object ...READ MORE

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

How purple 200/500/700 define in the color.xml of a new Android Project?

A new Android project provides a set ...READ MORE

Nov 23, 2022 in Android by Ashwini
 • 5,430 points • 4,642 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,730 points
edited Mar 5, 2025 • 496 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,730 points
edited Mar 5, 2025 • 495 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,730 points
edited Mar 5, 2025 • 494 views
0 votes
1 answer

Asset Write off calculation Automation

How about this in O29: =LET(period, ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
 • 38,000 points • 1,031 views
0 votes
1 answer

Converting Textboxes Link and/or Formula to Values in a Copied Sheet using Excel VBA

Copy the values using Range and Value2 With ActiveSheet.UsedRange ...READ MORE

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

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 5,912 views
0 votes
1 answer

xlsx package:Write excel file to a custom path

The issue is that when you send ...READ MORE

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

How can I use the Azure DevOps Pipeline with a specific older version of Ruby?

For a project I'm working on, Ruby ...READ MORE

Feb 7, 2023 in DevOps on Cloud by Damonlang
 • 1,230 points
edited Mar 4, 2025 • 1,344 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,730 points
edited Mar 5, 2025 • 487 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,730 points
edited Mar 5, 2025 • 484 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,730 points
edited Mar 5, 2025 • 481 views
0 votes
0 answers

Cannot find class in classpath in selenium

[RemoteTestNG] detected TestNG version 7.4.0 org.testng.TestNGException: Cannot find ...READ MORE

Feb 17, 2023 in Selenium by Tinju
edited Mar 4, 2025 • 913 views
0 votes
1 answer

What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

Jan 30, 2023 in Others by narikkadan
 • 86,360 points • 1,663 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,730 points
edited Mar 5, 2025 • 475 views
0 votes
0 answers

Does the string "php?id=1" within a http GET request mean there is necesseraly an sql request to a back-end database?

You can use Google dorks like "inurl:.php?id=" ...READ MORE

Aug 6, 2022 in PHP by Kithuzzz
 • 38,000 points • 9,279 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,730 points
edited Mar 5, 2025 • 473 views
0 votes
1 answer

Looking to create a conditional statement in excel

Try using a rule based on a ...READ MORE

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

Finding duplicate values in 5 excel sheets and results to be moved in the sixt one

See this article: VBA duplicated values coloring. I ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 86,360 points • 1,179 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,730 points
edited Mar 5, 2025 • 467 views
0 votes
1 answer

How can I replace the nth occurence using regex in VBA?

Use: =RegexReplace("This 9 is 8 a 77 6 ...READ MORE

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

How to print the next row every time a function runs? (openpyxl)

Verify the indentation. I executed the sample ...READ MORE

Jan 7, 2023 in Others by narikkadan
 • 86,360 points • 2,644 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,730 points
edited Mar 5, 2025 • 460 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,730 points
edited Mar 5, 2025 • 458 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,730 points • 1,013 views
0 votes
1 answer

Excel Copy/ Paste Special with selected sheets not working

Application.DisplayStatusBar = True Is cancelling your ...READ MORE

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

How can I add a wildcard to my if formula (that also contains an or condition)

3 Try: The formula in B1: =IF(SUM(COUNTIF(A1,{"* IDE","* IDE-?"})),"Y","N") Or, a little ...READ MORE

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

DevOps: Epics and Features not showing up in Plan

Work items and dependency lines must appear ...READ MORE

Jan 3, 2023 in DevOps on Cloud by David
 • 220 points • 2,801 views
0 votes
1 answer

Microservices Architecture in NodeJS

It's great to hear that you're exploring ...READ MORE

Jun 2, 2023 in Node-js by anonymous
 • 1,420 points • 2,501 views
0 votes
1 answer

VBA code for dragging down contents of a cell

Change this ActiveCell.Offset(k + 7, 0).AutoFill Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(2, ...READ MORE

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

Autofill macro to autofill dates up to 31 days regardless of the month

If you wish to utilise a single ...READ MORE

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

Formula to remove every middle name in a cell in Excel

Use this: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1) What does it do? Finds the ...READ MORE

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

Is there an excel function to tell if a cell has a dependency?

I think there is no built-in function ...READ MORE

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

Defining last nine rows of data as range to copy values and transpose paste into another worksheet

Transpose Last Rows Sub PrintLastRowsAddress() ...READ MORE

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

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

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

Generate number by using Dynamic array (w/o VBA)

Try: The formula in F2: =IFERROR(REDUCE(HSTACK("Name",SEQUENCE(,MAX(D2#))),UNIQUE(A2#),LAMBDA(a,b,LET(c,BYROW(HSTACK(C2#,D2#),LAMBDA(d,MIN(d))),e,FILTER(HSTACK(B2#,B2#&"-"&c,D2#),A2#=b),VSTACK(a,HSTACK(b,XLOOKUP(SEQUENCE(,MAX(DROP(e,,2)))-1,TAKE(e,,1),INDEX(e,,2),0,1)))))),"") If you really happen to ...READ MORE

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

Unprotect an Excel file programmatically

Try this. It worked for me.  def Remove_password_xlsx(filename, ...READ MORE

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

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 86,360 points • 4,420 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,730 points • 942 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 • 594 views
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,781 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 • 472 views
0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 5,183 views
0 votes
1 answer

Excel function to dynamically SUM UP data based on matching rows and columns

Excel 365 for MAC should have the BYCOL function, Given: Your ...READ MORE

Jan 21, 2023 in Others by narikkadan
 • 86,360 points • 1,986 views
0 votes
5 answers

How to resolve this error “Jenkins Host key verification failed”?

HI Mam, Please check the following solution:: 1. Switch ...READ MORE

May 3, 2019 in Jenkins by anonymous
 • 66,622 views
0 votes
1 answer

Open SAP from Excel VBA

It just means that there is no ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 86,360 points • 6,870 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,530 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,613 views
0 votes
1 answer

Turning a .xlsx into multiple PDFs

You just need to adjust the font ...READ MORE

Jan 31, 2023 in Others by narikkadan
 • 86,360 points • 1,526 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.