Trending questions in Others

0 votes
1 answer

Amortization schedule for many rows using Excel Macro

Try this: Sub one() Dim intRate, loanLife, initLoan, payment ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 956 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,680 points • 11,684 views
0 votes
1 answer

I want to make Excel read a value in Calc and copy it to my sheet in Excel

Here is the sample code that will allow ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 63,600 points • 510 views
0 votes
1 answer

If Statement Not Working When Including Cells That Have Formulas

Try:  =IF(VALUE(A1)>10;1;0) I hope this helps you. READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,600 points • 679 views
0 votes
1 answer

How to create a bar graph in Excel 2010 by counts?

Read on usage of pivot charts: Procedure: Pivot Table: Select Data Insert ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 766 views
0 votes
1 answer

Is there a way to hide excel formula using Apache POI

In Excel, hiding formulae is a feature ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 1,196 views
0 votes
1 answer

How to express absolute cell references in Excel R1C1-style formulas?

If the formulas are in Column K ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,600 points • 1,014 views
0 votes
1 answer

Export HTML Table to Excel- Doesn't Open in Office 2010

We had the same issue too many ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 756 views
0 votes
0 answers

xcel VBA Chart counting and formatting

I want to develop a macro that ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 332 views
0 votes
1 answer

Xls to csv converter

Use xlrd - it's faster, cross-platform, and ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 718 views
0 votes
1 answer

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 863 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 1,203 views
0 votes
0 answers

locked textbox property set to true at worksheet

Hello, I have textboxes (activeX controls) on ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 310 views
0 votes
1 answer

Create charts in excel sheet [ in same sheet along with data C#]

Unfortunately, it's not that simple. Use the ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 63,600 points • 1,162 views
0 votes
1 answer

Excel formatting DD-MMM-YYYY, must be in this format

There is no special structure for months ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 1,189 views
0 votes
1 answer

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,600 points • 573 views
0 votes
1 answer

Data entry into web page from excel

Reading the File in PHP Example 1 How to ...READ MORE

Oct 10, 2022 in Others by narikkadan
 • 63,600 points • 1,173 views
0 votes
1 answer

Speed up Excel vba program

Not at all. I used it. You ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 744 views
0 votes
1 answer

Codeigniter convert excel file to pdf

This is a basic php script for ...READ MORE

Sep 27, 2022 in Others by narikkadan
 • 63,600 points • 1,750 views
0 votes
1 answer

Is there a way to lock cells after editing an excel sheet that's on sharepoint?

The Excel Web version (which, based on ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 1,422 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 63,600 points • 1,274 views
0 votes
1 answer

Merge and export Excel/Word/PDF to PDF

Use GroupDocs.Merger for .NET API to merge Word, Excel, ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 1,459 views
0 votes
1 answer

Conditional Formatting (IF not empty)

 Use Conditional formatting with the option "Formula ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 612 views
0 votes
1 answer

Excel plot against a date time x series [closed]

Try using an X-Y Scatter graph with ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 602 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 816 views
0 votes
1 answer

Quadratic and cubic regression in Excel

You need to use an undocumented trick ...READ MORE

Oct 1, 2022 in Others by narikkadan
 • 63,600 points • 1,516 views
0 votes
1 answer

Protect excel sheet but allow data entry with form

Try this: Private Sub Workbook_Open() ...READ MORE

Sep 30, 2022 in Others by narikkadan
 • 63,600 points • 1,560 views
0 votes
1 answer

How do I calculate Interest rate (R) from EMI formula if I know EMI, Principal (P) and Time (N)?

Try this: #include <iostream> #include <cmath> #include <boost/date_time/posix_time/posix_time.hpp> #include <boost/thread/thread.hpp> #define TOLERANCE ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 632 views
0 votes
1 answer

Converting all tabs of excel sheet to PDF

Using VBA, try it like this, for ...READ MORE

Sep 26, 2022 in Others by narikkadan
 • 63,600 points • 1,724 views
0 votes
1 answer

1-step shortcut to delete entire row in excel 2016

Highlight the whole row by clicking on ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 571 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

Oct 15, 2022 in Others by narikkadan
 • 63,600 points • 860 views
0 votes
1 answer

NodeJS Amazon AWS S3 getObject how to send file in API response to download

Server Side const aws = require('aws-sdk'); router.get('/getfilefroms3', async (req, ...READ MORE

Mar 24, 2022 in Others by gaurav
 • 23,260 points • 9,750 views
0 votes
1 answer

SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

 I ran into the same problem due ...READ MORE

Feb 23, 2022 in Others by Aditya
 • 7,680 points • 10,922 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 698 views
0 votes
1 answer

Using Excel Proper Function with exception | Excel

To accomplish this, you might need to ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 63,600 points • 508 views
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,110 views
0 votes
1 answer

Updating Powerpoint - Excel Link in Different Computer

You could look at the Excel shape's ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 63,600 points • 825 views
0 votes
1 answer

How to freeze an area in Excel?

Excel has a "Freeze panes" for this, ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,600 points • 701 views
0 votes
1 answer

ActiveWorkbook.SaveAs excel 2013 1004 error

Error reproduction: I was able to reproduce the ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,667 views
0 votes
1 answer

Statistical Kurtosis in relation to SPSS and MS excel

Kurtosis does not measure "peakedness" or "height" ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 564 views
0 votes
1 answer

Online MYSQL editor as an Excel-like spreadsheet

That depends on who are those users, ...READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,058 views
0 votes
1 answer

Adding Signature Line Word-Excel

Since there doesn't appear to be a ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 63,600 points • 787 views
0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

Do columns C and D contain your ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,600 points • 614 views
0 votes
1 answer

SharePoint - Excel Online - Edit in Excel and Edit in Browser multiple users

Here is the Microsoft article regarding co-authoring https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104?ui=en-US&rs=en-US&ad=US When ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 63,600 points • 1,218 views
0 votes
1 answer

Subtotal in result row returns 0 in excel table

Syntax SUBTOTAL(function_num,ref1,[ref2],...) The SUBTOTAL function syntax has the following ...READ MORE

Sep 25, 2022 in Others by narikkadan
 • 63,600 points • 1,614 views
0 votes
1 answer

Repeated Multiplication formula for Excel

Fun little problem using some basic maths: =A1*3^ROW(A1) READ MORE

Oct 8, 2022 in Others by narikkadan
 • 63,600 points • 1,017 views
0 votes
1 answer

VBA to unhide a column when opening a workbook

Use the workbook_open even within ThisWorkbook. READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 493 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

You could use AVERAGEIFS to make the ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,600 points • 1,284 views
0 votes
1 answer

Excel VBA Worksheet Range storage location best practices

Solution Changing Worksheets' Code Name Why dim srcSheet as myWorksheet when ...READ MORE

Oct 21, 2022 in Others by narikkadan
 • 63,600 points • 436 views
0 votes
1 answer

Counting distinct values in excel - frequency function

You can use COUNTIF to count the ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,600 points • 477 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.