Trending questions in Edureka Community

0 votes
1 answer

Excel Formula Extract any number greater than x charters from a string

Given that you employ two separate delimiters, ...READ MORE

Feb 16, 2023 in Others by narikkadan
• 63,680 points
423 views
0 votes
1 answer

How do I add a custom script to my package.json file that runs a javascript file?

Hello @kartik, I have created the following, and ...READ MORE

Jul 16, 2020 in Node-js by Niroj
• 82,880 points
41,215 views
0 votes
1 answer

Do Until replay tree times

Clean Data: Apply Consistent Formatting in Columns Option ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,680 points
551 views
0 votes
0 answers

What are the requirements to become AWS DevOps Engineer?

Could someone please let me know what ...READ MORE

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

Excel VBA - Out of memory when create a dynamic array formula

Try this: Sub MyArray() Range("A1").Formula2 = "=R[2]C[2]:R[2]C[6]" End Sub But that ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
715 views
0 votes
1 answer

How can I automatically formulate a column while adding values ​to another? EXCEL

Use a # in your range references ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
378 views
0 votes
0 answers
0 votes
1 answer

Use of min and max functions in C++

The functions fmin and fmax are designed ...READ MORE

Jun 21, 2022 in C++ by Damon
• 4,960 points
11,081 views
0 votes
1 answer

I need help connecting my python file to excel to execute the output of my program to excel

you can replace concat with append and its will work but ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,680 points
907 views
0 votes
1 answer

OR and IF function for multiple values

Your OR functions will always return TRUE ...READ MORE

Feb 13, 2023 in Others by narikkadan
• 63,680 points
516 views
0 votes
1 answer

Excel: How to set a dropdown list cell to fetch list of strings from an API JSON response

The values you wish to display in ...READ MORE

Jan 30, 2023 in Others by narikkadan
• 63,680 points
1,120 views
0 votes
1 answer

Typescript: Can't find names - Error: cannot find name

A known issue: https://github.com/angular/angular/issues/4902 Core reason: the .d.ts file implicitly included ...READ MORE

Jun 7, 2022 in TypeSript by Nina
• 3,060 points
11,421 views
0 votes
0 answers

Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails

I'm trying to reverse-engineer an Azure SQL ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
481 views
0 votes
1 answer

Excel Power Query Moves old Data to the right

Just empty the page and then add ...READ MORE

Feb 16, 2023 in Others by Kithuzzz
• 38,020 points
343 views
0 votes
1 answer

How To Copy/Cut Row of Data Based on TRUE/FALSE Condition [Excel VBA]

Solution Loop through the rows on the Price ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,680 points
893 views
0 votes
0 answers

What are the prerequisites for AWS Certified DevOps Engineer Professional certification?

Could someone please let me know what ...READ MORE

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

Index and Match multiple matches

You can try the following (formula 1) ...READ MORE

Feb 10, 2023 in Others by narikkadan
• 63,680 points
631 views
0 votes
1 answer

Send message using excel to whatsapp web reloading

Inputs Range("W_C") = A list of Contacts' telephone ...READ MORE

Sep 21, 2022 in Others by narikkadan
• 63,680 points
6,770 views
0 votes
1 answer

How to query a matrix for multiple values and receive value

Try: =IFERROR(INDEX(SORT(SORT(FILTER(MATRIX, (LENGTHS>length)*(WEIGHTS>weight)),1,1),2,1),1,3),1) , where MATRIX, LENGTHS, and WEIGHTS ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
583 views
0 votes
1 answer

Application.Workbooks(V_WBNameOutPut).Activate alternative

You can capture the workbook when it's ...READ MORE

Feb 18, 2023 in Others by narikkadan
• 63,680 points
271 views
0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

Feb 7, 2023 in Others by narikkadan
• 63,680 points
743 views
0 votes
0 answers

What is the role of Advanced SME in Azure Synapse Analytics?

I watched a training video for Azure ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
448 views
0 votes
1 answer

PowerQuery Extract everything before alphabet from a column

Add column, custom column, with formula: = ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
640 views
0 votes
0 answers

DevOps Engineer Roles And Responsibilities

What are the various duties of an ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
443 views
0 votes
0 answers

Best way to keep Azure Postgres in sync with Azure SQL

For the use of pretty much everything, ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
435 views
0 votes
1 answer

Searching Multiple Criteria In Large Data Set to make new Data Set Excel VBA

Copy the data to an array, filter ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,680 points
1,021 views
0 votes
1 answer

Hide or visible sheets

Use a loop instead of repeating very similar ...READ MORE

Feb 10, 2023 in Others by narikkadan
• 63,680 points
584 views
0 votes
0 answers

which phase of software production are the focus of devops?

Which phase(s) of software products are the ...READ MORE

Dec 22, 2022 in DevOps & Agile by Edureka
• 13,620 points
2,763 views
0 votes
1 answer

Output python dataframe to excel and create a new data_validation column in the exported excel sheet

Use pandas.ExcelWriter with worksheet.data_validation from xlswriter : df["code"] = None items = list(range(1,10)) max_row, max_col = ...READ MORE

Jan 24, 2023 in Others by narikkadan
• 63,680 points
1,314 views
0 votes
0 answers

Getting error message about master.sys.sysclsobjs while converting SQL Server database to Azure

I have a database with SQL Server ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
412 views
0 votes
1 answer

Plot a legend outside of the plotting area in base graphics?

It appears that you are experiencing some ...READ MORE

Sep 8, 2023 in Data Science by anonymous
• 1,380 points
451 views
0 votes
0 answers

how to count the number of methods other than OPTION on AWS API Gateway with python?

I need to count the number of ...READ MORE

Feb 14, 2023 in AWS by Ashwini
• 5,430 points
416 views
0 votes
0 answers

Azure Data Engineer Associate certificate - preparation, Microsoft learn platform

Has anyone tried using Microsoft's online training ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
400 views
0 votes
1 answer

Having trouble hiding activecell column across tabs using vba

You might keep track of the location ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
599 views
0 votes
1 answer

Macro /excel date format change

You must handle the string Date differently ...READ MORE

Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
375 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,620 points
354 views
0 votes
1 answer

Iterator should return strings, not bytes (the file should be opened in text mode)

You can read the data of the ...READ MORE

Jan 21, 2023 in Others by narikkadan
• 63,680 points
1,410 views
0 votes
0 answers

How do I transition to DevOps Engineer?

Could you please tell me how to ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
392 views
0 votes
1 answer

Inferior statement

Try this: =IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death& ...READ MORE

Feb 10, 2023 in Others by narikkadan
• 63,680 points
530 views
0 votes
1 answer

To Keep only 1 header while merging Multiple file

There is potential for improvement here, such ...READ MORE

Jan 31, 2023 in Others by narikkadan
• 63,680 points
957 views
0 votes
1 answer

How to increment a column value if it repeats, otherwise reset to 1?

Use COUNTIF: =COUNTIF(A$2:A2,A2) The absolute and relative cell coordinates ...READ MORE

Feb 4, 2023 in Others by narikkadan
• 63,680 points
782 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,690 points
366 views
0 votes
1 answer

Excel VBA: Auto increment cell value after each printing

Print Copies of Single Worksheet With Increment Option ...READ MORE

Jan 22, 2023 in Others by narikkadan
• 63,680 points
1,338 views
0 votes
1 answer

Python Error when I'm converting Excel to JSON

The "Birth Year" value in the p ...READ MORE

Feb 5, 2023 in Others by narikkadan
• 63,680 points
724 views
0 votes
1 answer

How to read A column in xlsx file with pandas?

You can view all the columns with: excel_data.head() ...READ MORE

Feb 9, 2023 in Others by narikkadan
• 63,680 points
544 views
0 votes
1 answer

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
• 63,680 points
2,402 views
0 votes
0 answers

Dump DDL for EXTERNAL FILE FORMAT - Azure SQL DW

If one had used CREATE EXTERNAL FILE FORMAT ...READ MORE

Feb 14, 2023 in Azure by Damonlang
• 1,230 points
341 views
0 votes
1 answer

How do I copy a specific range of cells after I use AutoFilter in VBA?

Set the range of filtered data Set Rng ...READ MORE

Feb 2, 2023 in Others by narikkadan
• 63,680 points
823 views
0 votes
1 answer

Sort numeric values VBA

Try: The formula in B1: =SORTBY(A1:A8,LEFT(A1:A8&"0000 ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
433 views
0 votes
0 answers

What should be the career objective for DevOps Engineer?

Could someone please tell me what a ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
• 12,690 points
317 views