Trending questions in Others

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 • 4,278 views
0 votes
1 answer

How to subtract dates in Excel with different date formats?

You can use dates in any computation ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 1,445 views
0 votes
1 answer

Reading Excel file using node.js

Several distinct libraries perform Excel file parsing ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 2,485 views
0 votes
1 answer

Name for excel graph problem with the vba generator

Change the name of the workbook : Sub Macro_name_graph2() ...READ MORE

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

Excel - Stack Data based in Condition

Try this : =TEXT(SORT(FILTER(B:B,(B:B>=TIMEVALUE("00:04:00"))*(A:A="Available"),""),1,1),"h:mm:ss") It appears you tried Filter ...READ MORE

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

Is it possible to see more than 65536 rows in Excel 2007?

Here is an interesting blog entry about the ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 2,250 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

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

Use python to remove blank cells from column and shift populated cells up

Use pandas to import and modify your excel. import pandas ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 2,456 views
0 votes
1 answer

Excel Count if with index match

Try this: Countif(Index(rangeoflookupvalues,,match(Columnvaluetobe ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 2,225 views
0 votes
1 answer

Excel - External link to multiple workbooks

Try the INDIRECT() function. But this won't automatically update ...READ MORE

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

Excel Power Query Group by

Try this let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = ...READ MORE

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

Highlighting Unique List of Words in Each Cell of a Selection of Cells - Excel VBA

In a Textbox it is a vbcrlf ...READ MORE

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

How many sheets are there in Excel Workbook by default?

It is 3. As stated officially by ...READ MORE

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

Trying to make my VBA run a little bit faster

Using Variables In regards to efficiency, that's about ...READ MORE

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

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 86,360 points • 2,869 views
0 votes
1 answer

How to merge two Tables and Add the amount at the same time?

Use SUMPRODUCT like this: =SUMPRODUCT(($A$2:$A$5=A10)*$B$2:$B$5)+ ...READ MORE

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

Opening large Workbooks in excel

Here is a code I tried to ...READ MORE

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

Why this Excell formula that take the value of a cell and concatenate to the value or another cell is not working?

If J17's value is a true or ...READ MORE

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

Excel Conditional Formating to find numbers a cell with text

Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE

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

Excel VBA- Creation of a New datablock with criteria

To insert the dropdown, you can go ...READ MORE

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

Why is my code grabbing row number from the wrong Excel sheet?

I changed this: iTotalRows = source.Worksheets("Export").Range("B1:B" & Cells(Rows.Count, ...READ MORE

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

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

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

Is there a way to quickly check what attribute the data is in a cell in a spreadsheet?

Excel will automatically make assumptions about the ...READ MORE

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

Excel: How to analyze data in a table that contains multivalue cells

 The below formula will create a unique ...READ MORE

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

Textjoin with adjacent headers and rows with a twist

Try the following formula- =TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>"")) To make it ...READ MORE

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

How to convert excel to PDF using Python

Specify your whole output path instead of ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 3,396 views
0 votes
1 answer

How can I measure time more precisely in VBA?

At the top of the script you ...READ MORE

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

How to validate values entered in a multiline Excel cell?

Try: The formula in B1: =AND(BYROW(TEXTSPLIT(A1," "," ",1),LAMBDA(x,SUM((LEN(x)={3,7,4,4,5})ISNUMBER(-x)(MID(TAKE(x,-1),3,1)="."))))) Or, write a ...READ MORE

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

Create Drop-Down List Using a Formula (Without Data Validation)

As far as I am aware, it ...READ MORE

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

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

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

Need help to delete rows in VBA

Here is a basic macro that deletes ...READ MORE

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

Get selected value of a dropdown's item using jQuery

To answer your question, start with using ...READ MORE

Feb 18, 2022 in Others by Aditya
 • 7,680 points • 14,787 views
0 votes
1 answer

Numbering/sequencing sets of same column values

You can accomplish this with countif and a sliding ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 86,360 points • 1,023 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

Dec 24, 2022 in Others by narikkadan
 • 86,360 points • 1,409 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

Dec 23, 2022 in Others by narikkadan
 • 86,360 points • 1,494 views
0 votes
1 answer

How to make lambda function working on excel365?

Use this: =BYROW(SEQUENCE(5),LAMBDA(b,TEXTJOIN(",",,SEQUENCE(1,5,b)))) The second sequence is changed from ...READ MORE

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

Excel how to find the default file extension

Make a dict of xlfileformats:extensions and use ...READ MORE

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

Map-like array function in Excel?

In Excel-365 you can directly use ABS() function with array of ...READ MORE

Jan 9, 2023 in Others by narikkadan
 • 86,360 points • 741 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 • 5,129 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 86,360 points • 1,291 views
0 votes
1 answer

Excel VBA - Using Error Traps where Another Routine is Called

Macro1 is illegible as syntax. After the ...READ MORE

Jan 12, 2023 in Others by narikkadan
 • 86,360 points • 583 views
0 votes
0 answers

Object cannot be cast from DBNull to other types

I am getting this error and I am ...READ MORE

May 14, 2022 in Others by Kichu
 • 19,040 points • 2,684 views
0 votes
1 answer

Copy last 3 rows, excluding the rows for which there is a "0" in column "C"

The copy inside the loop is overwriting ...READ MORE

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

Excel:- Comparing 2 columns and then copying value in 3rd column

There is an excel if() function for ...READ MORE

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

Transform Excel table columns (not all) into rows - long to wide transformation

In PQ, highlight the Group column and ...READ MORE

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

How to turn a string formula into a "real" formula?

Evaluate might suit: Function Eval(Ref As String) ...READ MORE

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

How do I transpose a column to a matrix in Excel?

With data in column A, pick some cells ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 86,360 points • 2,617 views
0 votes
0 answers

Public variable for captura path in vba excel

I need to record the path of ...READ MORE

Jan 22, 2023 in Others by Kithuzzz
 • 38,000 points
edited Mar 4 • 144 views
0 votes
1 answer

Convert Excel to PDF using JavaScript

You're clobbering objExcel on line 15: var objExcel ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 86,360 points • 4,636 views
0 votes
1 answer

ASP.NET generated excel file has different format than extension

You must include the xlsx file extension. The ...READ MORE

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