Trending questions in Others

0 votes
1 answer

Insert picture into Excel cell

You can add the image into a ...READ MORE

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

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

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

Convert image (jpg) to base64 in Excel VBA?

Heres a function. Can't remember where I ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 86,360 points • 5,566 views
0 votes
1 answer

A value which should be judged by a scale gets bad judgement sometimes

Only the period (.) is accepted by ...READ MORE

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

DATEDIF Excel - output incorrect

If you want the difference in days, ...READ MORE

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

SQL query to select dates between two dates

you should put those two dates between ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 24,280 points • 3,795 views
0 votes
1 answer

Excel to CSV with UTF8 encoding

Use of Google Spreadsheet is a straightforward ...READ MORE

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

Excel - Find the Max for Total revenue just for year 1

In Office365 and LibreOffice Calc, there is ...READ MORE

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

Converting PDF to Excel using Adobe PDF Tool API in .NET

An identical mistake was occurring for me ...READ MORE

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

Convert xls to csv without any data changes

Here are the 3 solutions I have ...READ MORE

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

Excel Formula Help Conditional Formatting - If A2 =TODAY and B2=Y turn A2 Green. If B2 = N turn A2 RED

Create a conditional format rule on A2 ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 86,360 points • 1,453 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, 2025 • 431 views
0 votes
1 answer

Excel formula to convert EST date time into IST date time?

The code: =IF(A1-TIME(10,30,0)<0,ABS(1+A1-TIME(10,30,0)),A1-TIME(10,30,0))  It works if your cell ...READ MORE

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

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Here's how to accomplish things in another ...READ MORE

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

VBA Excel Adding pictures to a worksheet

It should work as: ActiveSheet.Pictures.Insert("C:\Work\test_Project\myjpgfile.jpg").Select As that's all the ...READ MORE

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

How to sum column until current row?

Use the Header as your starting point: =SUM(Table1[[#Headers],[Num ...READ MORE

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

Excel-How can I get the address of a cell instead of a value?

There are various difficulties in this. Which ...READ MORE

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

What is the character code for new line break in excel

Use CHAR(10) and Turn on Wrap Text option. It ...READ MORE

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

How to draw wedge shape with outline in Excel VBA?

According to https://learn.microsoft.com/en-us/office/vba/api/excel.adjustments: Because each adjustable shape has a ...READ MORE

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

How to create page borders using Apache POI in excel files with Java?

Microsoft Excel cannot do this. Libreoffice Calc ...READ MORE

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

Filter sumproduct formula based on array

Use ISERROR(MATCH()): =SUMPRODUCT(--(ISERROR(MATCH(Sales[Area];Exceptions[Area];0)));Sales[Quantity];Sales[Price per unit]) --(ISERROR(MATCH(Sales[Area];Exceptions[Area];0))) will return 1 if the ...READ MORE

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

Imitate Excel style gradient color effect (red, yellow, green) in gt::data_color()

The similar color palette: c("#63be7b", "#ffeb84", "#f8696b") df %>% ...READ MORE

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

Excel - count days between two dates per year

Put this in C2 and copy over: =MIN(DATE(C1,12,31),$B$2)-MAX(DATE(C ...READ MORE

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

Activating a Specific Cell in Excel Using VBA Results to Error 400

I think you trying to select cells(4, ...READ MORE

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

How to avoid using Select in Excel VBA

Every time you record macros and reuse ...READ MORE

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

How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

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

HTTP Error 403.14 - Forbidden - The Web server is configured to not list the contents of this directory

Try keeping this into your web config ...READ MORE

Feb 11, 2022 in Others by Rahul
 • 9,690 points • 15,216 views
0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 86,360 points • 5,498 views
0 votes
1 answer

Excel grade formula

Since you said it was just for ...READ MORE

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

Why percentage calculation in excel gives me incorrect numbers

Please be specific with your query. Do ...READ MORE

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

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

Sep 23, 2022 in Others by narikkadan
 • 86,360 points • 5,571 views
0 votes
1 answer

How to add Indian Rupee Currency symbol in Google Spreadsheet

To apply a custom currency format to ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 24,280 points • 3,549 views
0 votes
1 answer

PHPExcel generated excel file not auto-calculating formula

By recalculating on the server side, it ...READ MORE

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

Unhide all Hidden Excel Columns Without Individual Iteration?

I discovered that the best way to ...READ MORE

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

How do I get an Excel range using row and column numbers in VSTO / C#?

Use: int countRows = xlWorkSheetData.UsedRange.Rows.Count; int countColumns = xlWorkSheetData.UsedRange.Columns.Count; object[,] ...READ MORE

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

Excel VBA advanced filter to exclude data

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

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

Hiding the formula bar in Excel for a specific file

No, you cannot. Unfortunately, altering the CustomUI file ...READ MORE

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

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

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

How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 5,611 views
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 5,480 views
0 votes
1 answer

Excel there was a problem sending the command to the program

Solution: You go to Regedit -> HKEY_CLASSES_ROOT\Excel.Sheet.12\Shell\Open : change ...READ MORE

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

Excel Formula/Function to Subtract randomly

The first number we use: =RANDBETWEEN(1,A1) Then the second: =RANDBETWEEN(1,A1-B1) Then ...READ MORE

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

How to remove Blank Rows using EPPlus Excel Package Plus

It is checking the last row if ...READ MORE

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

How to reference Microsoft.Office.Interop.Excel dll?

Use NuGet (VS 2013+): The NuGet package manager ...READ MORE

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

Cannot detect strikeout data from excel using apache poi

You must first obtain the RichTextString, then ...READ MORE

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

How to create exponential growth in excel over a year

To find an interest rate that will ...READ MORE

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

How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

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

How can I format bytes a cell in Excel as KB, MB, GB etc?

In Excel's formatting features, computations are not ...READ MORE

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

Compare Two columns If 2 cells are Matching

Although I find it difficult to follow ...READ MORE

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

Is it possible to create Pivot Chart with source data as Pivot Table using Apache POI?

Using apache POI separately, I can make ...READ MORE

Dec 15, 2022 in Others by Kithuzzz
 • 38,000 points • 1,831 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.