Trending questions in Others

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,620 points • 525 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,620 points • 481 views
0 votes
1 answer

Deleting Empty rows in Excel using VBA

On Error Resume Next worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0 When ...READ MORE

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

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

Oct 2, 2022 in Others by narikkadan
 • 63,620 points • 1,304 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,620 points • 331 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,620 points • 419 views
0 votes
1 answer

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,620 points • 1,455 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,620 points • 1,027 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,620 points • 592 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,620 points • 365 views
0 votes
1 answer

Convert three letter country codes to full country names

Just create a list to be used in ...READ MORE

Oct 16, 2022 in Others by narikkadan
 • 63,620 points • 616 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,620 points • 872 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,620 points • 651 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,620 points • 336 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,620 points • 634 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,620 points • 317 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,620 points • 779 views
0 votes
1 answer

Excel to IBM DB2 Connection

Try using the IBM DB2 for I ...READ MORE

Sep 29, 2022 in Others by narikkadan
 • 63,620 points • 1,338 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,620 points • 777 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,620 points • 453 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,620 points • 618 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,620 points • 362 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,620 points • 788 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,620 points • 433 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,620 points • 473 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,620 points • 330 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,620 points • 579 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,620 points • 263 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,620 points • 1,359 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,620 points • 302 views
0 votes
1 answer

React Native and iOS share button

In this article, we will be learning ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,260 points • 558 views
0 votes
1 answer

Excel - IFERROR Function

Use: =IF(ISNUMBER(FIND("Bob",A2)),"Other",A2) Remember FIND is an exact match while SEARCH does not care ...READ MORE

Oct 20, 2022 in Others by narikkadan
 • 63,620 points • 288 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,620 points • 979 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

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

How to open an Excel Online document as a PDF

In light of your comment above, I ...READ MORE

Oct 18, 2022 in Others by narikkadan
 • 63,620 points • 357 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,620 points • 783 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,620 points • 958 views
0 votes
1 answer

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

Oct 17, 2022 in Others by narikkadan
 • 63,620 points • 385 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,620 points • 1,138 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,620 points • 771 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,620 points • 974 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,620 points • 1,041 views
0 votes
1 answer

Excel Tax Calculator

You can replace it with a set ...READ MORE

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

Disable Postback on button ASP.NET c#

If you're dynamically adding controls to the ...READ MORE

May 30, 2022 in Others by rajiv
 • 1,620 points • 6,415 views
0 votes
1 answer

Excel VBA - Trouble importing WhatsApp chat history files into an Excel sheet

Since the OpenText method isn't working for ...READ MORE

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

Show tick symbol on label

Try this code: LblTick.Text = ((char)0x221A).ToString(); Easier method: lblTick.Text ...READ MORE

Oct 16, 2022 in Others by narikkadan
 • 63,620 points • 341 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,620 points • 691 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,282 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,620 points • 1,165 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,620 points • 1,240 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.