Trending questions in Others

0 votes
1 answer

Excel Lookup function for text

Use a simple VLOOKUP() function like: =VLOOKUP(E2,$A$2:$B$6,2,FALSE) You can also use ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 1,657 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,392 views
0 votes
1 answer

Spire When Pdf-ing an excel file it leaves some formulas as System.Object[][]

Since you tested the Excel file and ...READ MORE

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

Cannot connect to Excel SSIS

You need to set run64BitRuntime to False. ...READ MORE

Sep 24, 2022 in Others by narikkadan
 • 86,360 points • 5,121 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,375 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,641 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 • 3,018 views
0 votes
1 answer

Integrating address verification based on pincode and vice versa for Indian Pincode

The other website you pointed to () ...READ MORE

Dec 13, 2022 in Others by narikkadan
 • 86,360 points • 1,635 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,385 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,208 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,868 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,434 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,466 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,627 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,517 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,939 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,902 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 • 4,100 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 • 3,083 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 • 3,083 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,253 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,437 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 • 3,063 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,423 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 • 3,094 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 • 4,003 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,646 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,789 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 • 5,088 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 • 4,074 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,851 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,686 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,552 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,716 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,184 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,529 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,729 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,855 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,282 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,546 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,974 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 • 3,018 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 • 3,065 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 • 2,092 views
0 votes
1 answer

Excel formula to calculate contribution

For several component numbers, you may obtain ...READ MORE

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

Calculate slope and intercept value for logarithmic trendline as excel

You missed Math.log() for ln() in Excel. ...READ MORE

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

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

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