Trending questions in Others

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
790 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,782 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,131 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
696 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
824 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
907 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
819 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
648 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,162 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,886 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
456 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
2,173 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
572 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
555 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
540 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
837 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
709 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
575 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
1,005 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
869 views
0 votes
1 answer

Camel case converter in an excel

Try this: =LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_","") ...READ MORE

Nov 19, 2022 in Others by narikkadan
• 63,600 points
4,154 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
824 views
0 votes
1 answer

Calculating accuracy within excel

Format the cell in Col C as ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 63,600 points
2,679 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,686 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
751 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,313 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
360 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
651 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
816 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
813 views
0 votes
1 answer
0 votes
1 answer

VBA code help - Add a line for each missing date with the start and end date defined in a cell

Try this: Sub FillDates() Dim ...READ MORE

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

React useEffect Hooks with setTimeout

I am so confused here with React ...READ MORE

Jan 27, 2023 in Others by Tejashwini
• 3,820 points
1,118 views
0 votes
1 answer

How to remove data within a multi-line cell that comes after a few line breaks

find() return the starting position of a ...READ MORE

Jan 26, 2023 in Others by narikkadan
• 63,600 points
1,130 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
603 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
421 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
803 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
456 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
584 views
0 votes
1 answer

How to clear TextField Entered Text automatically in Flutter?

Hi@akhtar, You can control the TextField in your ...READ MORE

Sep 10, 2020 in Others by MD
• 95,460 points
38,573 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Call the API property to activate the autofilter: import xlwings ...READ MORE

Dec 23, 2022 in Others by narikkadan
• 63,600 points
2,568 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
570 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
913 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
426 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
768 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
720 views
0 votes
1 answer

Compare each excel sheets with a table in oracle

One way to verify the count and ...READ MORE

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

CodeIgniter: Unable to connect to your database server using the provided settings Error Message

 I'm assuming there is something wrong with ...READ MORE

Feb 16, 2022 in Others by Soham
• 9,710 points
15,884 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
• 63,600 points
659 views