Trending questions in Others

0 votes
1 answer

How to use relative names in Excel VBA

It appears you are looking for Range.Offset() http://msdn.microsoft.com/en-us/library/office/ff840060%28v=office.15%29.aspx However, you ...READ MORE

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

Formatting Excel Spreadsheet using Apache POI in JAVA

Try this: CellRangeAddress range= new CellRangeAddress(firstrow, lastrow, firstcol, ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 86,360 points • 3,976 views
0 votes
1 answer

Using C# to find drawn arrows in Excel

There are 28 different varieties of arrow ...READ MORE

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

Search for number and degree symbol

The Instr and Like operators are not mutually excluding which means ...READ MORE

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

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 86,360 points • 3,955 views
0 votes
1 answer

Adjust cell width in Excel

Use set_column as follows: worksheet1.set_column(1, 1, 25) This is defined as ...READ MORE

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

c#, Microsoft Interop Excel , change font style for s selected range

Change your code to this: worksheet.get_Range("B3", "B4").Cells.Font.Name = ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 86,360 points • 3,748 views
0 votes
1 answer

Excel formula that combines MATCH, INDEX and OFFSET

Try this: =INDEX((OFFSET(SheetA!F:F,0,SheetA!A1)),MATCH(SheetB!C4, ...READ MORE

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

What would I have to add to this VBA Code to keep Undo Button working after it runs?

VBA eliminates Excel's undo function. Though it ...READ MORE

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

Division formula in excel

You may use this Array formula in ...READ MORE

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

Excel/Python: How to group names alphabetically section wise such that each group has equal number of Alphabets?

Here is a flimsy answer. The number ...READ MORE

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

Standard deviation only for data that meets two conditions in Excel

I would say: =STDEV.S(IF((A2:A11="A")*(B2:B11="Z1"),C2:C11,"")) ...READ MORE

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

Excel concatenate function with multiple conditions

Use this : =TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Sl ...READ MORE

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

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

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

Activate last excel worksheet on worksheetlist with closedxml in c#

This will answer your question :  Changing ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 3,473 views
0 votes
0 answers

VBA SQL Connection to Excel from Word returns no records

Trying to figure out how to read ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,648 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

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

Add a shape to a specific cell in Excel

When you use SORT() or data->sort on ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 86,360 points • 3,973 views
0 votes
1 answer

Convert PDF to XLS

To ensure that data import makes sense, ...READ MORE

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

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 86,360 points • 3,736 views
0 votes
1 answer

Convert Word doc, docx and Excel xls, xlsx to PDF with PHP

After receiving a request, I'll put the ...READ MORE

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

How can i get name box from excel?

You could add a VBA function to ...READ MORE

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

'npm' is not recognized as internal or external command, operable program or batch file

To your existing lines of code, include ...READ MORE

Feb 10, 2022 in Others by Rahul
 • 9,690 points • 14,968 views
0 votes
1 answer

Apache POI. Setup data filters in Excel

It's already enabled in Apache POI 3.7. ...READ MORE

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

Excel date format mismatch

Due to the fact that the "dates" ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 86,360 points • 3,656 views
0 votes
1 answer

Calculate the mean from excel sheet for specific rows

Generate a list for each means you ...READ MORE

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

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

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

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

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

How to get sum of all matches of HLOOKUP in Excel?

Consider: =SUMPRODUCT((A1:E1="apple")*(A2:E2)) To include more ...READ MORE

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

How to remove or delete comments in excel worksheet?

Get a range, then clear comments: Worksheets("MySheet").Activate ActiveSheet.UsedRange.ClearComments I ...READ MORE

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

Write from R into template in excel while preserving formatting

you have the XLConnect package. Read the documentation or the vignette of that ...READ MORE

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

How to add Header and Footer in excel with vb.net?

This code will work: Imports Microsoft.Office.Interop Private Sub Button1_Click(sender ...READ MORE

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

Non-exact Vlookup with multiple search criteria - Microsoft Excel

Use the array function: =INDEX(A$2:A$100,MATCH(9^99,SEARCH(B2,A$2:A$100)*SEARCH(C2,A$2:A$100))) This will work with Ctrl+Shift+Enter but not ...READ MORE

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

Apache POI - watermark in Excel - different appearance in Excel and LibreOffice

There is nothing that apache poi could ...READ MORE

Oct 9, 2022 in Others by narikkadan
 • 86,360 points • 4,531 views
0 votes
0 answers

Insert multiple rows when range contains specific text

I am trying to have a macro ...READ MORE

Dec 24, 2022 in Others by Kithuzzz
 • 38,000 points • 1,284 views
0 votes
1 answer

Opening or downloading an excel file from aspx web page fails: It doesn't open in application

In regards to your first edit, the ...READ MORE

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

How to break area chart in excel

Add an extra row between your areas. READ MORE

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

Create a pie chart of ages, showing under 30's, 30-50's, and over 50's

Two things: A pie chart does not aggregate ...READ MORE

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

'Microsoft.Office.Interop.Excel.Range' does not contain a definition for 'get_Default'

You are using C# version 4, the ...READ MORE

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

Excel is saying zero is not equal to zero

It is a floating point error. Increase ...READ MORE

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

How to remove values from drop-down if value deleted from validation list

Try this code: Private Sub Worksheet_Change(ByVal Target As ...READ MORE

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

Excel Issue- custom format for Turkish currency

What about: #.##0,00 [$₺-tr-TR] Where #.##0,00 € would do for ...READ MORE

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

Excel VLOOKUP between two sheets failing

Try this: =VLOOKUP(A2,'1'!$A$2:$E$811,5,0) I altered "1"! $A$2:$A$811 to '1'! ...READ MORE

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

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

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

Excel VBA code window opened cropped and can't view code

So it turns out after some online ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 1,675 views
0 votes
0 answers

Subtotal and Sum gives different result

I'm totally at a loss with this ...READ MORE

Jan 7, 2023 in Others by Kithuzzz
 • 38,000 points
edited Mar 4, 2025 • 626 views
0 votes
1 answer

Word Mail Merge with Excel data has to be saved in different files with custom names

Try this: Public Sub Mail_Merge() On Error GoTo ErrH Dim ...READ MORE

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

Tab Delimited Text Copy Paste To Excel

By switching the element my text was ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 86,360 points • 3,589 views
0 votes
1 answer

Excel how to fill all selected blank cells with text

Do the following to place the same ...READ MORE

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

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

Since you tested the Excel file and ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 86,360 points • 2,406 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.