Most answered questions in Others

0 votes
1 answer

Which is better normal desktop window or MDI like excel and chronos

How people interact with your system entirely ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 230 views
0 votes
1 answer

Displaying a portion of a table in a separate worksheet

If you are using Excel 2013 or ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 356 views
0 votes
1 answer

Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 1,187 views
0 votes
1 answer

Calculating the mean and std on excel file using python

Use pandas to do this: import pandas as pd df = ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 1,744 views
0 votes
1 answer

How to return a result from a VBA function

You must associate the value with the ...READ MORE

Nov 4, 2022 in Others by narikkadan
 • 63,620 points • 1,353 views
0 votes
1 answer

Android: how to write a file to internal storage

Android offers openFileInput and openFileOutput from the ...READ MORE

Nov 4, 2022 in Others by gaurav
 • 23,260 points • 1,463 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,260 points • 728 views
0 votes
1 answer

Writing python code on android

Download Pydroid 3 – IDE for Python ...READ MORE

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

Excel VSTO - cm/inches to point conversion not accurate

You may convert centimetres to points in ...READ MORE

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

Excel Formula multiple Index Match and Average the result

If the conditions are separate and unrelated, ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 63,620 points • 2,695 views
0 votes
1 answer

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

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

Frequency Array formula EXCEL not calculating

You obtain the same outcome, which suggests ...READ MORE

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

Detect whether Excel workbook is already open

Try this: Option Explicit Sub Sample() ...READ MORE

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

Formula to convert KG,MB,GB,TB to GB in excel

Use this array formula: =LEFT(A1,MIN(IFERROR(FIND({"KB","MB","GB","TB"},A1),1E+99))-1)/INDEX({1048576,1024,1,0.0009765625},MATCH(RIGHT(A1,2),{"KB","MB","GB","TB"},0)) & "GB" Being an ...READ MORE

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

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

Oct 31, 2022 in Others by narikkadan
 • 63,620 points • 12,603 views
0 votes
1 answer

c#, Microsoft Interop Excel , change font style for s selected range

Change your code to this: worksheet.get_Range("B3", "B4").Cells.Font.Name = ...READ MORE

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

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

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

Excel date format mismatch

Due to the fact that the "dates" ...READ MORE

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

Find occurrence count of a number in Excel

First split those integer values into their ...READ MORE

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

Indent table pasted from Excel into Word

It is feasible to pick up the ...READ MORE

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

Excel custom format: What does [$€-2] mean?

The 2 in [$€-2] is a "Numeral ...READ MORE

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

Converting .pdf files to excel (.xls)

It is not always possible and typically ...READ MORE

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

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

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

Password Protecting an Excel file in C#

Try this: using Microsoft.Office.Interop.Excel //create your spreadsheet here... WorkbookObject.Password = ...READ MORE

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

How to export data with functions to another workbook in excel

The issue appears to be that once ...READ MORE

Oct 30, 2022 in Others by narikkadan
 • 63,620 points • 325 views
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,620 points • 491 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,620 points • 407 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,620 points • 4,057 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,620 points • 332 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,620 points • 547 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,620 points • 1,843 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,620 points • 806 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,620 points • 294 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,620 points • 432 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,620 points • 363 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,620 points • 1,335 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,620 points • 315 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,620 points • 1,002 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,620 points • 861 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,620 points • 411 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,620 points • 392 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,620 points • 3,847 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,620 points • 2,959 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,620 points • 572 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,620 points • 343 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,620 points • 341 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,620 points • 863 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,620 points • 788 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,620 points • 298 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.