Trending questions in Others

0 votes
1 answer

Word Mail Merge with Excel data has to be saved in different files with custom names

Try this: Public Sub Mail_Merge() On Error GoTo ErrH Dim ...READ MORE

Nov 6, 2022 in Others by narikkadan
 • 86,360 points • 3,087 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
 • 86,360 points • 3,430 views
0 votes
1 answer

How to change compound annual growth rate (CAGR) formula depending on data existing/not existing?

Sep to calculate CAGR. Excel has an ...READ MORE

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

Excel If Functions with Multiple Conditions

Use this: =IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum"))) I added <=0 just in case you have ...READ MORE

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

HLOOKUP in Excel Formula

If you want to switch up the ...READ MORE

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

How many is too many columns (safely) in Excel?

I'll just share a story with you. ...READ MORE

Dec 16, 2022 in Others by narikkadan
 • 86,360 points • 1,344 views
0 votes
1 answer

How to convert an excel formula to SQL to calculate daily compound interest

Here is a solution that is effective. ...READ MORE

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

How to get second-highest salary employees in a table

SELECT MAX(SALARY) FROM Employee WHERE SALARY < ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 3,026 views
0 votes
1 answer

How to clear contents of an Excel Workbook through vba

When the range you're referring to doesn't ...READ MORE

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

Add user-defined function (UDF) to built-in category in Excel

Use Application.MacroOptions This example adds a user-defined macro ...READ MORE

Dec 15, 2022 in Others by narikkadan
 • 86,360 points • 1,302 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
 • 86,360 points • 4,149 views
0 votes
1 answer

Opening or downloading an excel file from aspx web page fails: It doesn't open in application

In regards to your first edit, the ...READ MORE

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

Rich text format (with formatting tags) in Excel to unformatted text

This function ought to be helpful if ...READ MORE

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

In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

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

How to separate Unit/Suite/APT/# from an address in Excel

Use batch geocode your file on geocoder.ca This ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 1,726 views
0 votes
1 answer

Adding a percentage sign to a number field in Excel

Format these cells with custom format ?\% READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 1,503 views
0 votes
1 answer

Convert Excel to Word using Aspose.Word for Java

However, Aspose.Cells APIs cannot directly convert Excel ...READ MORE

Dec 10, 2022 in Others by narikkadan
 • 86,360 points • 1,719 views
0 votes
1 answer

Extract Uppercase Words on Excel

Try the following User Defined Function: Public Function ...READ MORE

Nov 14, 2022 in Others by narikkadan
 • 86,360 points • 2,603 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
 • 86,360 points • 3,289 views
0 votes
1 answer

Import online excel file in google spreadsheet?

The function is: /** * Convert Excel file ...READ MORE

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

Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

Sep 21, 2022 in Others by narikkadan
 • 86,360 points • 4,931 views
0 votes
1 answer

I have filtered my Excel data and now I want to number the rows. How do I do that?

Solution Filter your data. Select the cells you want ...READ MORE

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

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

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

Excel VBA is not recording macro properly

The "awkward code" is an R1C1 notation ...READ MORE

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

Excel sum formula without table - Equivalent to the Math Sum Symbol

You can use SUMPRODUCT for this. Assuming X is in cell B1, ...READ MORE

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

Convert table in a jpg image to excel using python

I believe you must execute OCR (optical ...READ MORE

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

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

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

How to "Print" Excel Sheet on Custom Page Size like Din A1?

Try turning the pdf file into an ...READ MORE

Oct 11, 2022 in Others by narikkadan
 • 86,360 points • 4,021 views
0 votes
1 answer

Get Excel data in DataTable

The JET/Access driver has a number of ...READ MORE

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

When doing a MERGE in Oracle SQL, how can I update rows that aren't matched in the SOURCE?

I see you asked it a long ...READ MORE

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 2,883 views
0 votes
1 answer

(Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

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

Is there a way to remove password in a Excel file (.xls) using shell in Linux with known password?

Dig into the Excel documentation for the ...READ MORE

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

How to open an Excel file in C#?

You must have Microsoft Visual Studio Tools ...READ MORE

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

How can I convert excel file to pdf using TCPDF?

PHPExcel can only read charts from Excel2007 ...READ MORE

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

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

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

Check whether a cell contains a substring

Try using this: =ISNUMBER(SEARCH("Some Text", A3)) This will return TRUE if ...READ MORE

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

How to fix corrupted imported online excel in google sheet?

Issue and workaround: In the built-in functions for ...READ MORE

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

How to create and download excel document using asp.net

First, download the Open XML Format SDK 2.0. It comes ...READ MORE

Oct 3, 2022 in Others by narikkadan
 • 86,360 points • 4,308 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 • 2,772 views
0 votes
1 answer

Excel delete row if column contains value from to-remove-list

Given sheet 2: ColumnA ------- apple orange You can flag the rows ...READ MORE

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

Excel dropdown with name/value pairs

Solution Define a range to use as the ...READ MORE

Oct 7, 2022 in Others by narikkadan
 • 86,360 points • 4,108 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
 • 86,360 points • 3,360 views
0 votes
1 answer

Microsoft.Office.Interop.Excel for Office 2007

Each client must install the  2007 Microsoft ...READ MORE

Nov 5, 2022 in Others by narikkadan
 • 86,360 points • 2,835 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
 • 86,360 points • 3,217 views
0 votes
0 answers

Bootstrap modal: is not a function

When I call my model in windows ...READ MORE

May 5, 2022 in Others by Kichu
 • 19,040 points • 10,771 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
 • 86,360 points • 2,830 views
0 votes
2 answers

Attempted import error: 'Switch' is not exported from 'react-router-dom'

import it from material UI there will ...READ MORE

Sep 1, 2022 in Others by anonymous
 • 7,888 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

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

Control cell value from another cell in Excel

You may accomplish this by using two ...READ MORE

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

Sending excel data to Tally

You can use Requests to send the ...READ MORE

Nov 19, 2022 in Others by narikkadan
 • 86,360 points • 2,159 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.