Trending questions in Others

0 votes
1 answer

Excel VBA - Delete empty rows

Try this: sub foo() dim r As ...READ MORE

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

Is it possible to round to different decimal places in excel based on the range?

Where the range is multiple cells: Excel.Worksheet sheet ...READ MORE

Nov 17, 2022 in Others by narikkadan
 • 86,360 points • 1,745 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 • 2,249 views
0 votes
1 answer

Excel SUMIFS() using string with greater/less than symbols

Put an = in front to let Excel know ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 86,360 points • 1,646 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 • 2,511 views
0 votes
1 answer

Spell check an Excel sheet in VBA

Use this code to check the whole ...READ MORE

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

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

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

Using standard deviation function in excel for a specific criteria?

Use this: =STDEV(IF((A1:A1000>=-0.5)*(A1:A1000<=0.5),A1:A1000)) Depending on one's version this may ...READ MORE

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

Combining MID and LEFT Functions in Excel 2019

I currently have a course name and ...READ MORE

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

How to add check symbol in excel cell SXSSFSheet java

Try this: import java.io.FileOutputStream; import org.apache.poi.xssf.streaming.*; class CreateSXSSFUnicode { public ...READ MORE

Nov 13, 2022 in Others by narikkadan
 • 86,360 points • 1,935 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 • 3,225 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,661 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,963 views
0 votes
1 answer

Get last modified object from S3 using AWS CLI

Try this command $ aws s3api list-objects --bucket ...READ MORE

Sep 20, 2022 in Others by anonymous
edited Mar 5, 2025 • 8,127 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
 • 25,250 points • 2,115 views
0 votes
1 answer

Paste special issue, From Excel to Word

Since the table in the word document ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 86,360 points • 1,598 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
 • 25,250 points • 2,283 views
0 votes
1 answer

Convert an excel file (xls,xlsx) for PDF

Try this: import java.io.FileInputStream; import ...READ MORE

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

Using "If cell contains #N/A" as a formula condition.

Input the following formula in C1: =IF(ISNA(A1),B1,A1*B1) Screenshots: When #N/A: When not ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 86,360 points • 1,510 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
 • 25,250 points • 3,178 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 • 3,046 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 • 2,086 views
0 votes
1 answer

Python: Convert PDF to DOC

Install LibreOffice and try this: lowriter --invisible --convert-to ...READ MORE

Nov 15, 2022 in Others by narikkadan
 • 86,360 points • 1,782 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
 • 25,250 points • 2,080 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 • 2,211 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,557 views
0 votes
0 answers

How to reduce a huge excel file

I have a short, straightforward *.XLS file ...READ MORE

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,284 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,747 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 • 3,033 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 • 2,470 views
0 votes
1 answer

How to open a huge excel file efficiently

A good example is using PIA's/Interop or ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 86,360 points • 2,553 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 • 2,074 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,424 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,886 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,747 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
 • 86,360 points • 3,868 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,586 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,974 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,749 views
0 votes
1 answer

Transposing columns to rows in Excel

Don't know solution but, I am in ...READ MORE

Nov 2, 2022 in Others by Mantas
edited Mar 5, 2025 • 2,878 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,653 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 • 2,419 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,811 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
 • 86,360 points • 3,731 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,979 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 • 3,279 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 • 2,019 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,440 points • 1,385 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,496 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,493 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.