Trending questions in Others

0 votes
1 answer

How do I create a hyperlink from Word to Excel specific cell, without macros/vba?

All you have to do is copy ...READ MORE

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

Excel is not updating cells, options > formula > workbook calculation set to automatic

This occurred to me today in a ...READ MORE

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

Cell character counting formula?

With data in column A, in B1 enter: =SUMPRODUCT(--(LEN(A:A)=ROW())) Then copy downwards: I ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,052 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

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

How to convert .xls to .pdf via PHP?

You can use PHPExcel to read the XLS ...READ MORE

Nov 8, 2022 in Others by narikkadan
 • 86,360 points • 1,642 views
0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

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

Excel create an Index on the first sheet with links to subsequent sheets

Below example shows how to use the ...READ MORE

Oct 22, 2022 in Others by narikkadan
 • 86,360 points • 2,366 views
0 votes
1 answer

Formatting Phone Numbers in PHP

This is a US phone formatter that ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,621 views
0 votes
1 answer

Excel calculating drop rates

Each column's "total" row is just the ...READ MORE

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

Can R do the equivalent of an HLOOKUP nested within a VLOOKUP?

When working in a program like R, ...READ MORE

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

Removing all page breaks from a Crystal Reports 2016 v14 -> Excel export

Try ExportFormatType.ExcelRecord instead of ExportFormatType.Excel. It will ...READ MORE

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

How to add Conditional Formatting in Excel for a Range of Values

Three distinct rules are required, one for ...READ MORE

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

How To Use VBA To Share Excel File With Fellow Office User?

PowerApps were referenced; if you have a ...READ MORE

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

Pivot Tables in MS Excel (Office 365)

If you create the required result table ...READ MORE

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

Excel VBA: How to change order of scenarios

I'm trying to run a VBA loop ...READ MORE

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

Can I show a formula result in a pop-up window in Microsoft Excel?

Yes, you can display the formula result—that ...READ MORE

Nov 12, 2022 in Others by narikkadan
 • 86,360 points • 1,395 views
0 votes
1 answer

Using c# to select a worksheet in excel

Try this: Excel.Worksheet xlWorkSheetFocus = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2); xlWorkSheetFocus.Activate(); I hope this ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 1,303 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

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

Count cells in excel with populated values

Use: =SUMPRODUCT(--(CHOOSE({1,2,3,4,5},A1, A4, A6, A8, A10)<> ...READ MORE

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

Excel dashboard using slicers when cell contains multiple values

All values in the column are displayed ...READ MORE

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

Wrap text of Table cell in exported Excel in BIRT

Export as XLS in 4.4.2 (not xlsx). ...READ MORE

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

'App not Installed' Error on Android

In order to allow installation of apps ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 1,708 views
0 votes
0 answers

How to merge two sorted arrays into a sorted array?

this question was asked in interview  public static ...READ MORE

Nov 17, 2022 in Others by Ashwini
 • 5,430 points • 999 views
0 votes
1 answer

Xamarin iOS app displaying white blank screen on iPad after update to Xcode 11

Assuming you have your iPad Pro connected ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,580 points • 2,613 views
0 votes
1 answer

Excel cells don't calculate until I double-click them

Select all, find-replace = with =, and ...READ MORE

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

Excel Ribbon Macro not enabled

If you place a breakpoint in one ...READ MORE

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

Excel shared formula expansion

You can use Linq I would start ...READ MORE

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

Using a UDF in Excel to update the worksheet

The MSDN KB is incorrect. It says A user-defined function called ...READ MORE

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

Excel VBA : HOW TO PRINT THE TEXT IN A CELL (like Wrap Text)

Use a LineFeed character to create a ...READ MORE

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

Export many small DataFrames to a single Excel worksheet

Try  this: from pandas import ExcelWriter def dfs2xlsx(list_dfs,xls_path = ...READ MORE

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

Convert a single png file to jpg in vba

Try this code: Sub ConveretPNGToJpg() ...READ MORE

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

Large excel file, I'm trying to find duplicates and copy the rest of the cells across the duplicate to the duplicate it finds

Copy the column from the other sheet ...READ MORE

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

How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK($C:$C,$C2,4),0)) To divide into whichever many ...READ MORE

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

Is there a function in excel to find duplicates

Solution: You can use Conditional formatting inside the ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 1,222 views
0 votes
1 answer

Reversing Text to Columns in Excel/Calc

There are built-in functions that will allow ...READ MORE

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

What is this value means 1.845E-07 in excel?

The precise value, expressed in scientific notation, ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 1,550 views
+1 vote
1 answer

How to use VBA in Excel for Google Search?

Try this: Private Const LicenseRegistration As String = ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 2,807 views
0 votes
1 answer

Rename Excel worksheets from range

Rename Worksheets Using a List There are a ...READ MORE

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

Showing percentages above bars on Excel column graph

Solution  Use a line series to show the ...READ MORE

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

Is there a way to transfer MSWord numbering bullets to MSExcel column?

Your numbered bullets can be copied from ...READ MORE

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

How to Import Excel Worksheet into Microsoft Project?

Solution: Wizard's preliminary settings: New map As a new project Tasks, ...READ MORE

Oct 14, 2022 in Others by narikkadan
 • 86,360 points • 2,517 views
0 votes
1 answer

Removing specific rows in an Excel file using Azure Data Factory

Under the 'Source' tab, choose the number ...READ MORE

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

How to merge two cells in excel with same field name

Insert 2 new columns, G & H. Enter ...READ MORE

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

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

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

Excel issue "excel 4.0 function stored in defined names"

I don't want to revive an old ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 1,553 views
0 votes
1 answer

Find function to locate result of a formula, in a cell

There are several attributes to the Find ...READ MORE

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

Find the differences between 2 Excel worksheets?

Place your column in column A of ...READ MORE

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

Excels INDEX with MATCH for multiple criteria

How to Use INDEX MATCH With Multiple Criteria ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,401 views
0 votes
1 answer

Logical calculation in Excel

Excel logical functions - overview. Microsoft Excel ...READ MORE

Nov 8, 2022 in Others by gaurav
 • 23,580 points • 1,381 views
0 votes
1 answer

Excel formula: Correct syntax of SUM with ROW?

A few explanations of why your formula ...READ MORE

Nov 10, 2022 in Others by narikkadan
 • 86,360 points • 1,294 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.