Trending questions in Edureka Community

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,006 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 • 447 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,235 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,427 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 • 470 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 • 288 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 • 461 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 • 628 views
0 votes
0 answers

Is DevOps engineer a good job?

Can somebody tell me if working as ...READ MORE

Feb 14, 2023 in DevOps & Agile by Edureka
 • 12,690 points • 291 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 • 610 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,331 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 • 557 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 • 941 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,154 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,048 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 • 375 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,538 views
0 votes
1 answer

jQuery text() and newlines

text('this\n has\n newlines); The newline character is \n ...READ MORE

Jun 15, 2022 in JQuery by rajatha
 • 7,680 points • 10,760 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 • 664 views
0 votes
1 answer

How can increase the speed of if statement in VBA Code?

Use a Dictionary Object. Option Explicit Sub PreencherO() ...READ MORE

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

Having issues with pop-up alert in excel. (Visual Basic)

You may find the following code of ...READ MORE

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

Is there a faster way to delete table rows so my script doesn't take hours to run?

This is for your rowAddressToRemove variable. So instead of ...READ MORE

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

How can one sort a list of dictionaries into an excel sheet such that each unique key and one corresponding key are placed into columns?

With pandas, you can use something like this ...READ MORE

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

Newbie needs Excel suggestions with a simple script

Formula to Count the Number of Occurrences ...READ MORE

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

What VBA Code to Hide Excel Quick Access Toolbar?

Use this: Sub HideQuickAccessTB() Application.ExecuteExcel4Macro ...READ MORE

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

Exclude worksheets from loop with a list

You can achieve this by making a ...READ MORE

Feb 11, 2023 in Others by Kithuzzz
 • 38,000 points • 326 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 • 4,860 views
0 votes
1 answer

Is there an efficient way to do this excel function

Use vlookup(): VLOOKUP(E2,$B$4:$C$8,2,1) READ MORE

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

Getting data out of a cell with a #NAME? error in Excel VBA

If you need VBA, use .Formula: Dim f As ...READ MORE

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

Hide contents of drop-down list in Excel with password?

So, 3 versions all relatively similar: Above shown ...READ MORE

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

Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Moving your string into an array first ...READ MORE

Feb 2, 2023 in Others by narikkadan
 • 63,600 points • 691 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
 • 63,600 points • 344 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
 • 63,600 points • 473 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
 • 63,600 points • 679 views
0 votes
1 answer

How do I make my subs() not change inputdata in Vba excel

Use the ByVal keyword to pass on ...READ MORE

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

VBA - user input of row value to use in a cell range

Use this: Range("C" & c & ":I" & ...READ MORE

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

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

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

How to sum the next n non-empty cells in LibreOffice Calc?

Here's a volatile solution (assuming you don't ...READ MORE

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

Multiple Arguments Excel

Use the SWITCH function: =SWITCH(IFERROR(INDEX(FILTER([Recording.xlsx]Wednesday!$D$2:$D$26,[Recording.xlsx]Wednesday!$B$2:$B$26<>""),ROW()-2),""),"Y","Accepted","N","Refused","") This way, you avoid ...READ MORE

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

Find max and second max salary for a employee table MySQL

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 23,260 points • 4,449 views
0 votes
1 answer

Fixed position but relative to container

The issue with "fixed" positioning is that ...READ MORE

Jun 28, 2022 in CSS by Edureka
 • 12,690 points • 10,077 views
0 votes
1 answer

How to arrange a string to display

It's a bad idea to use spaces ...READ MORE

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

How to remove borders from cells in a range in Excel using VB.net?

range.Borders(Excel.XlBordersIndex.xlEdgeLeft).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeRight).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeTop).LineStyle = Excel.XlLineStyle.xlLineStyleNone range.Borders(Excel.XlBordersIndex.xlEdgeBottom).LineStyle ...READ MORE

Jan 5, 2023 in Others by narikkadan
 • 63,600 points • 1,844 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
 • 63,600 points • 489 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,245 views
0 votes
1 answer

Export ListBox Data to Sheet range

Use ListCount to retrieve the number of ...READ MORE

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

Compare 2 columns in same excel sheet in pandas

Try this: import pandas as pd import numpy as ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 63,600 points • 2,692 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
 • 63,600 points • 435 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.