Trending questions in Edureka Community

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,600 points • 761 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,600 points • 1,150 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 • 556 views
0 votes
1 answer

Violation Long running JavaScript task took xx ms

These messages are classified as warnings rather ...READ MORE

Nov 15, 2022 in Java by Damonlang
 • 1,230 points • 4,466 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,600 points • 970 views
0 votes
1 answer

How do I change the menu language of Excel Online?

Click on App launcher from any worksheet ...READ MORE

Apr 1, 2022 in Database by gaurav
 • 23,260 points • 14,333 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 • 549 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 • 540 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,600 points • 565 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 • 542 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 • 492 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,600 points • 722 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,000 points • 385 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,600 points • 1,494 views
0 votes
1 answer

Blazor - ClosedXml - excel cannot open the file beacause the file format or extension is not valid

Changed the following code: function BlazorDownloadFile(filename, bytesBase64) { var ...READ MORE

Jan 20, 2023 in Others by narikkadan
 • 63,600 points • 1,582 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,600 points • 927 views
0 votes
0 answers

How to decrypt a password from SQL server?

Use the following SQL Server 2000 query: select ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
 • 38,000 points • 8,604 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,600 points • 2,555 views
0 votes
1 answer

Excel formula in Pandas

 Use this: df['col2'] = df['col1'].shift().lt(df['col1']).astype(int) I hope this helps ...READ MORE

Jan 6, 2023 in Others by narikkadan
 • 63,600 points • 2,164 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,420 points • 532 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,600 points • 305 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,600 points • 986 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 • 490 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,600 points • 642 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,600 points • 849 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,600 points • 1,051 views
0 votes
1 answer

Excel file download using java - Error : File is corrupted

Try this: @GetMapping("/downloadDOA") public ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,600 points • 2,514 views
0 votes
1 answer

How do I output the row containing the lowest value from a specific column inside a filtered dynamic array?

Instead of using 1 filter function to ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,600 points • 771 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,600 points • 639 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 • 390 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 • 431 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,000 points • 409 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 • 416 views
0 votes
1 answer

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,600 points • 5,061 views
0 votes
1 answer

Reshape excel table with stacked date column

I agree that using a pivot makes ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,600 points • 722 views
0 votes
1 answer

Google Spreadsheet/ Excel - how to find matching values in column A, having necessary values in column M

Try this: =COUNTIF($M$2:$M$5;A2) If the product is present in ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 550 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,000 points • 504 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 • 388 views
0 votes
1 answer

How can I rename each column of a table?

Add Name For Each Column Sub AddNames() ...READ MORE

Feb 7, 2023 in Others by narikkadan
 • 63,600 points • 667 views
0 votes
1 answer

How to rename a workbook other than using (Name) and (FileSystemObject. MoveFile)?

Use  SHFileOperation API Option Explicit Private Declare PtrSafe Function SHFileOperation ...READ MORE

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

Copy the respective values from another workbook depend on specific conditions

Try this: Sub Get_Respective_Values_Of_Last_Closing_Date() Dim wb1 ...READ MORE

Feb 6, 2023 in Others by narikkadan
 • 63,600 points • 705 views
0 votes
1 answer

Error populating email body from word documents

There is no need to use late ...READ MORE

Jan 15, 2023 in Others by narikkadan
 • 63,600 points • 1,653 views
0 votes
1 answer

Conditional formatting with Index(Match), 2 conditions (vertical & horizontal)

Use FILTER to search using two or ...READ MORE

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

VBA Create and Rename Tables

Convert Table to Excel Table (ListObject) Option Explicit Sub ...READ MORE

Jan 24, 2023 in Others by narikkadan
 • 63,600 points • 1,258 views
0 votes
1 answer

Excel Visual Basic managing coordinate tuple type

A tuple can be saved as an ...READ MORE

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

Excel to Word Macro resulting in Run-time error 462

Are you attempting this (UNTESTED)? I've commented ...READ MORE

Jan 29, 2023 in Others by narikkadan
 • 63,600 points • 1,033 views
0 votes
1 answer

Excel: Count distinct numerical values if string condition matches

FILTER Shipper and Month based on Employee ...READ MORE

Feb 10, 2023 in Others by narikkadan
 • 63,600 points • 510 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 • 322 views
0 votes
1 answer

Ordering data in python or excel

Basically, the data is converted from wide ...READ MORE

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

How to get columns from Excel files using Apache POI?

The only way to see all the ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 5,455 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.