Latest questions in Others

0 votes
1 answer

How do I specify a variable Excel range?

Try this: =SUM(OFFSET(A1,0,1,1,3)) To break it down: OFFSET(reference cell, ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,700 points • 512 views
0 votes
1 answer

Excel - Unable to open https// <<PATH>> Cannot download the information you requested ---- How to disable

You can find the answer to your ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,700 points • 417 views
0 votes
1 answer

Get Code Isin from Bloomberg with Excel formula

In answer to the follow-up, BQL is ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 4,112 views
0 votes
1 answer

Excel viewer lib

 Try http://viewerjs.org. You will need to save your ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 341 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
 • 63,700 points • 579 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

In addition, INDEX MATCH is a more ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 1,869 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
 • 63,700 points • 817 views
0 votes
1 answer

Shortcut to Apply a Formula to an Entire Column in Excel

Try double-clicking on the bottom right hand ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 305 views
0 votes
1 answer

Display a table (in the html/Excel spreadsheet meaning) in a iOS app in Swift

Here is the answer to your question: How ...READ MORE

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

Tab Delimited Text Copy Paste To Excel

By switching the element my text was ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 369 views
0 votes
1 answer

How to hide and unhide the columns of an excel sheet using asp.net

Use this. For Row: worksheet_sub.Row(i).Height = 0; For Column: ...READ MORE

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

How can I copy from specific sheet in excel

You should use wb.Sheets("Name of sheet").Copy - ...READ MORE

Oct 29, 2022 in Others by narikkadan
 • 63,700 points • 319 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
 • 63,700 points • 1,014 views
0 votes
1 answer

Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 883 views
0 votes
1 answer

Multiple find and replace in MS Word from a list in MS Excel

If I understand you correctly, you want ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 430 views
0 votes
1 answer

Too Many Different Cell Formats

Cell formats are challenging. There isn't actually ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 402 views
0 votes
1 answer

SSIS Excel Connection Manager failed to Connect to the Source

It seems like the 32-bit version of ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 3,898 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 3,007 views
0 votes
1 answer

How to use goal seek function in Excel user function?

In the Microsoft Excel Object-Sheet1(Sheet1), we can ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 581 views
0 votes
1 answer

How to manually piece together a fraction on excel

Instead of controlling formatting in your calculations, ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 353 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

Oct 28, 2022 in Others by narikkadan
 • 63,700 points • 358 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
 • 63,700 points • 888 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
 • 63,700 points • 810 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,700 points • 308 views
0 votes
1 answer

Highlight active row/column in Excel without using VBA?

Create two formula-based rules: =ROW()=CELL("row") =COLUMN( ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 63,700 points • 2,538 views
0 votes
1 answer

Auto fill in the blanks in Excel

Considering the information below: Step 1: Choose ...READ MORE

Oct 27, 2022 in Others by narikkadan
 • 63,700 points • 530 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
 • 63,700 points • 401 views
0 votes
1 answer

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

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

Excel VBA Rnd Not Actually Random

 Initialize the random number function. Sub test() Dim number ...READ MORE

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

Test or check if sheet exists

Some people don't like this strategy because ...READ MORE

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

Formatting Excel Spreadsheet using Apache POI in JAVA

Try this: CellRangeAddress range= new CellRangeAddress(firstrow, lastrow, firstcol, ...READ MORE

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

Convert Feet to meters in excel with macro for entire column

You can convert Feet to Kilometers using ...READ MORE

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

Get number of columns of a particular row in given excel using Java

Use: int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells(); Or int noOfColumns = sh.getRow(0).getLastCellNum(); There ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 2,701 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 566 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,700 points • 338 views
0 votes
1 answer

How to create a dependent drop down list using [Apache POI]

There is nothing apache poi cannot do, ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 4,932 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 2,084 views
0 votes
1 answer

Ignore text values in subtotal function

Use 7 as the second criterion in AGGREGATE instead ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 552 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
 • 63,700 points • 839 views
0 votes
1 answer

How to insert info into online excel spreadsheet with python selenium

I recently discovered one of my options, ...READ MORE

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

Add a shape to a specific cell in Excel

When you use SORT() or data->sort on ...READ MORE

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

Convert Excel's "41014" date to actual date in PHP or JavaScript

PHPExcel Date handling code: public static function ExcelToPHP($dateValue ...READ MORE

Oct 24, 2022 in Others by narikkadan
 • 63,700 points • 3,597 views
+1 vote
1 answer

Excel macro to make selected range absolute or relative reference?

Try  this: Sub ConverReferenceType() On ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,700 points • 1,203 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,700 points • 491 views
0 votes
1 answer

Excel Arrow Key is Creating a Formula?

Your scroll lock is on. This is ...READ MORE

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

Getting SUM for hh:mm:ss in EXCEL

The times are probably preserved as text. SUM ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,700 points • 5,962 views
0 votes
1 answer

Excel VBA remove blank rows from specific range

I have tried to avoid .select  Option Explicit Sub CombineData() ...READ MORE

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

Convert word document to excel

See the solution here: https://superuser.com/questions/747197/how-do-i-copy-word-tables-into-excel-without-splitting-cells-into-multiple-rows In essence, I had ...READ MORE

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

Export a simple Dictionary into Excel file in python

You can use pandas. import pandas as pd dict1 ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,700 points • 5,692 views
0 votes
1 answer

Converting excel to pdf using PHP

If utilizing PHP on a Windows PC, ...READ MORE

Oct 23, 2022 in Others by narikkadan
 • 63,700 points • 4,842 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.