Most answered questions in Others

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
 • 63,620 points • 369 views
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
 • 63,620 points • 468 views
0 votes
1 answer

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

You can use OLEDB to create and ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 1,299 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
 • 63,620 points • 263 views
0 votes
1 answer

Excel Pivot Table : Calculated Field ( formula to be used like sumproduct)

With a calculated field, you might not ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 1,723 views
0 votes
1 answer

How to convert an XML file to an Excel file?

Create a CSV file that is in ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 1,284 views
0 votes
1 answer

Excel shortcut for month day year short date [closed]

What about Ctrl-1 + Tab + Tab + ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 358 views
0 votes
1 answer

Calculating a Rolling IRR in Excel

I'm assuming a little bit here, but ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 752 views
0 votes
1 answer

Excel grade formula

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

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 359 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
 • 63,620 points • 275 views
0 votes
1 answer

How can I convert uppercase letters to lowercase in Notepad++

Simply choose the text you wish to ...READ MORE

Jan 3, 2023 in Others by narikkadan
 • 63,620 points • 6,764 views
0 votes
1 answer

Random #NAME error only while running macro

For those who are wondering what happened ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,620 points • 211 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
 • 63,620 points • 271 views
0 votes
1 answer

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML(): Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,620 points • 346 views
0 votes
1 answer

What is the easiest way to convert an Excel spreadsheet with tabular data to JSON?

Assuming you really mean easiest and are not necessarily ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,620 points • 12,162 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
 • 63,620 points • 363 views
0 votes
1 answer

Stop Excel from automatically converting certain text values to dates

I've discovered that getting the desired result ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,620 points • 339 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
 • 63,620 points • 289 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
 • 63,620 points • 715 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
 • 63,620 points • 389 views
0 votes
1 answer

Excel VBA Protect Sheet without Locking all cells

If the problem is the use of Clear then ...READ MORE

Dec 29, 2022 in Others by narikkadan
 • 63,620 points • 548 views
0 votes
1 answer

Excel How to Remove Duplicate Rows in multiple of 3 Same Value

Put the following formula into a helper ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 348 views
0 votes
1 answer

xlsxwriter formatting is corrupting my excel file

The problem is that while attempting to ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 1,909 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
 • 63,620 points • 271 views
0 votes
1 answer

How to access entire row by cell address or value in excel?

You may accomplish all of this by ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 1,067 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
 • 63,620 points • 369 views
0 votes
1 answer

How to Convert nested JSON into excel in nodejs

Try this: const filtered = attendanceData.map(obj => { ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 2,313 views
0 votes
1 answer

Excel Formula - Calculating Total Percentage

You just need the AVERAGE of all ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 314 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
 • 63,620 points • 350 views
0 votes
1 answer

Ms-access vba - read from excel and also update that excel

Here is the code that works without ...READ MORE

Dec 28, 2022 in Others by narikkadan
 • 63,620 points • 1,181 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,620 points • 1,634 views
0 votes
1 answer

Excel COUNTIFS with merged cell

Although it is strongly advised to stay ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,620 points • 814 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
 • 63,620 points • 676 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
 • 63,620 points • 431 views
0 votes
1 answer

Convert excel file to jpg in c#

You can use Aspose : http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/category1129.aspx For example : http://www.aspose.com/docs/display/cellsnet/Converting+Worksheet+to+Image Sample ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,620 points • 739 views
0 votes
1 answer

Excel Connect data points with line is DISABLED

By replicating the data series and substituting ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,620 points • 1,043 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
 • 63,620 points • 373 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
 • 63,620 points • 246 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
 • 63,620 points • 373 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
 • 63,620 points • 360 views
0 votes
1 answer

Can I insert a file into Excel without creating a reference?

You can easily embed a PDF into ...READ MORE

Dec 27, 2022 in Others by narikkadan
 • 63,620 points • 259 views
0 votes
1 answer

Drawing an excellent cow

If you are on Linux and have cowsay installed ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 251 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
 • 63,620 points • 415 views
0 votes
1 answer

Excel VBA: Open Hyperlinks in a loop and copy paste download link in a sheet

Refer this tutorial for your solution: https://evermap.com/Tutorial_AB ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 1,021 views
0 votes
1 answer

How to find the last row in a column using openpyxl normal workbook?

ws.max_row will give you the number of rows ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 5,155 views
0 votes
1 answer

Calculating the week number of a year in Excel

Here is my excel formula. =IF(AND(A1>=DATE(YEAR(A1),1,1),A1< ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 291 views
0 votes
1 answer

How to subtract date only format "mm/dd" in excel?

I suppose Excel has handled December 21 ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 457 views
0 votes
1 answer

Get random value in the range of plus/minus 10% of a cell value in Excel

Why not just use RANDBETWEEN(B2*0.9, B2*1.1) if ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 482 views
0 votes
1 answer

Excel countif entire row in a table

Try this: =COUNTIF(B:B,"my citeria") so if your Column ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 426 views
0 votes
1 answer

How to Clear Table Style in Office Scripts?

Excel tables on the web are constantly ...READ MORE

Dec 25, 2022 in Others by narikkadan
 • 63,620 points • 510 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.