Latest questions in Others

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
 • 63,420 points • 445 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
 • 63,420 points • 590 views
0 votes
1 answer

Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 335 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
 • 63,420 points • 642 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
 • 63,420 points • 270 views
0 votes
1 answer

Excel: Median of even number of values with a condition

The LARGE function, COUNT function, and TRUNC ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 439 views
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 1,696 views
0 votes
1 answer

What does the " @ " symbol mean in Excel formula (outside a table)

Excel has recently introduced a huge feature ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 1,002 views
0 votes
1 answer

Countifs formula using weekday function

Use SUMPRODUCT: =SUMPRODUCT(((WEEKDAY(TODAY())>= 3)*(WEEKDAY(TODAY())<=6)*(INT(AG10:AG100)=INT(TODAY()-1)))+((WEEKDAY(TODAY())=2)*(INT(AG10:AG100)>=INT(TODAY()-3))*(INT(AG10:AG100)<=INT(TODAY()-1)))) If the Dates in AG ...READ MORE

Nov 26, 2022 in Others by narikkadan
 • 63,420 points • 418 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
 • 63,420 points • 416 views
0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 745 views
0 votes
1 answer

Loop formula in excel vba

You can use an IF statement to ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 601 views
0 votes
1 answer

Excel graphics with ggplot2

Excel's pseudo-3D charts are choked full of ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 375 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
 • 63,420 points • 648 views
0 votes
1 answer

How do I transpose a column to a matrix in Excel?

With data in column A, pick some cells ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 1,569 views
0 votes
1 answer

PHPExcel generated excel file not auto-calculating formula

By recalculating on the server side, it ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 1,216 views
0 votes
1 answer

How to add text on new page in word doc via excel vba

First start with: objDoc.Range.Insertafter vbCr & Chr(12) & ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 1,496 views
0 votes
1 answer

Concatenate columns using LEFT and RIGHT in EXCEL

It's conceivable that the Concat/Concatenate function isn't ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 288 views
0 votes
1 answer

Parsing from Excel multisheet file: List comprehension between columns

You can use read_excel with parameter sheetname=None for return all sheets ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 442 views
0 votes
1 answer

In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS($H$3:H3)<=$I$1,INDEX(Personnel! ...READ MORE

Nov 25, 2022 in Others by narikkadan
 • 63,420 points • 782 views
0 votes
1 answer

VBA to protect and unprotect in given range in sheet

It needs a minor tweak to become ...READ MORE

Nov 24, 2022 in Others by Kithuzzz
 • 38,010 points • 1,950 views
0 votes
1 answer

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 320 views
0 votes
1 answer

Prompt message if Excel column has some value in asp.net c#

I believe it is wise to use ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 442 views
0 votes
1 answer

How to look in all folders in directory to change file extensions of excel file?

Loop Through All Subfolders Using VBA Dim strCurrentFileExt ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 363 views
0 votes
1 answer

PHPExcel file cannot open file because the file format or file extension is not valid

Just change the code to this: // Save Excel ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 4,577 views
0 votes
1 answer

How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 913 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 1,892 views
0 votes
1 answer

How to use Excel VLOOKUP function with words that begin with the letters AB

If you lookup "AB" in Excel, it ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 938 views
0 votes
1 answer

How can i add cells if condition is met

Both the AND function and nested if ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 503 views
0 votes
1 answer

How to use an increment an average formula by more than one row in excel?

I believe OFFSET makes it simpler, for ...READ MORE

Nov 24, 2022 in Others by narikkadan
 • 63,420 points • 1,006 views
0 votes
1 answer

Excel formula to replace or stubstitute only text that starts with a certain letter

You're requesting a "formula." Normally, you would ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 269 views
0 votes
1 answer

Trouble pasting a Word equation into Excel

Use this: Sub ExpandEqn(MyText As String) ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 329 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
 • 63,420 points • 327 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
 • 63,420 points • 644 views
0 votes
1 answer

Generate VCards from Excel using VBA

Solution  Create a class called CContact with getters ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 534 views
0 votes
1 answer

How to automatically nest rows of an Excel spreadsheet using level values?

More grouping levels have been added to ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 481 views
0 votes
1 answer

How do delete an specific page in a word document using Excel VBA?

Check the code below. I eliminated the ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 1,032 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
 • 63,420 points • 275 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 456 views
0 votes
1 answer

Excel - function to convert first letter of each word to uppercase

there are two methods to do this: Method ...READ MORE

Nov 21, 2022 in Others by narikkadan
 • 63,420 points • 376 views
0 votes
1 answer

Excel: Cross-sheet reference not working

There are 2 possible things: Make sure the ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 7,709 views
0 votes
1 answer

Return empty cell from formula in Excel

There is no way to do this ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 4,135 views
0 votes
1 answer

How to remove gridlines on select cells in Google Sheets?

The google sheets don't have an exact ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 401 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
 • 63,420 points • 538 views
0 votes
1 answer

Convert Word doc, docx and Excel xls, xlsx to PDF with PHP

After receiving a request, I'll put the ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 973 views
0 votes
1 answer

Saving style of the header of StyleFrame.object to_excel

The correct way to style the headers ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 398 views
0 votes
1 answer

How can solve this Solver Excel like problem in R?

More details and explanations are required so ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 598 views
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

Nov 20, 2022 in Others by narikkadan
 • 63,420 points • 811 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
 • 63,420 points • 370 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
 • 63,420 points • 373 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.