Recent questions tagged excel-formula

0 votes
1 answer

Excel - IFERROR Function

Oct 20, 2022 in Others by Kithuzzz
 • 38,000 points • 1,134 views
0 votes
1 answer

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Oct 17, 2022 in Others by Kithuzzz
 • 38,000 points • 1,845 views
0 votes
1 answer

How do you calculate the Quintile for groups of rows in Excel?

Oct 16, 2022 in Others by Kithuzzz
 • 38,000 points • 2,734 views
0 votes
1 answer

Amortization schedule for many rows using Excel Macro

Oct 16, 2022 in Others by Kithuzzz
 • 38,000 points • 1,839 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

Oct 16, 2022 in Others by Kithuzzz
 • 38,000 points • 3,833 views
0 votes
1 answer

How to get sum of all matches of HLOOKUP in Excel?

Oct 16, 2022 in Others by Kithuzzz
 • 38,000 points • 3,916 views
0 votes
1 answer

Convert three letter country codes to full country names

Oct 16, 2022 in Others by Kithuzzz
 • 38,000 points • 2,217 views
0 votes
1 answer

How to express absolute cell references in Excel R1C1-style formulas?

Oct 15, 2022 in Others by Kithuzzz
 • 38,000 points • 2,350 views
0 votes
1 answer

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

Oct 15, 2022 in Others by Kithuzzz
 • 38,000 points • 3,574 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Oct 15, 2022 in Others by Kithuzzz
 • 38,000 points • 2,163 views
0 votes
1 answer

Converting Feet-Inches to Inches Excel

Oct 15, 2022 in Others by Kithuzzz
 • 38,000 points • 3,161 views
0 votes
1 answer

Insert pie chart in Excel macro function

Oct 14, 2022 in Others by Kithuzzz
 • 38,000 points • 2,030 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

Oct 14, 2022 in Others by Kithuzzz
 • 38,000 points • 1,953 views
0 votes
1 answer

How to split text values by a delimiter?

Oct 11, 2022 in Others by Kithuzzz
 • 38,000 points • 1,726 views
0 votes
1 answer

Excel Issue- custom format for Turkish currency

Oct 10, 2022 in Others by Kithuzzz
 • 38,000 points • 4,122 views
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

Oct 10, 2022 in Others by Kithuzzz
 • 38,000 points • 1,492 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

Oct 10, 2022 in Others by Kithuzzz
 • 38,000 points • 2,023 views
0 votes
1 answer

Excel formatting DD-MMM-YYYY, must be in this format

Oct 10, 2022 in Others by Kithuzzz
 • 38,000 points • 3,949 views
0 votes
1 answer

How Can I Round Prices to the nearest 0.95 with an Excel Formula?

Oct 9, 2022 in Others by Kithuzzz
 • 38,000 points • 1,698 views
0 votes
1 answer

Excel - compound interest with continuing contribution

Oct 7, 2022 in Others by Kithuzzz
 • 38,000 points • 1,541 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Oct 7, 2022 in Others by Kithuzzz
 • 38,000 points • 2,285 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

Oct 7, 2022 in Others by Kithuzzz
 • 38,000 points • 2,398 views
0 votes
1 answer

How to get rid of a #value error in Excel?

Oct 3, 2022 in Others by Kithuzzz
 • 38,000 points • 1,849 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Oct 3, 2022 in Others by Kithuzzz
 • 38,000 points • 3,289 views
0 votes
1 answer

Excel Formula Query on Summing Annual Leave Days and Half Days

Oct 3, 2022 in Others by Kithuzzz
 • 38,000 points • 3,582 views
0 votes
1 answer

Excel: Search for a list of strings within a particular string using array formulas?

Oct 3, 2022 in Others by Kithuzzz
 • 38,000 points • 3,666 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Oct 3, 2022 in Others by Kithuzzz
 • 38,000 points • 3,757 views
0 votes
1 answer

Calculate age in excel

Oct 2, 2022 in Others by Kithuzzz
 • 38,000 points • 1,776 views
0 votes
1 answer

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

Oct 2, 2022 in Others by Kithuzzz
 • 38,000 points • 1,975 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

Oct 1, 2022 in Others by Kithuzzz
 • 38,000 points • 2,555 views
0 votes
1 answer

How to define excel SUMIFS criteria considering any text and numbers?

Sep 30, 2022 in Others by Kithuzzz
 • 38,000 points • 2,348 views
0 votes
1 answer

Excel use SUMIF but with a multiplier before summation: x2, x3, x4, etc

Sep 29, 2022 in Others by Kithuzzz
 • 38,000 points • 2,256 views
0 votes
1 answer

Goal Seek in Excel

Sep 29, 2022 in Others by Kithuzzz
 • 38,000 points • 1,834 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

Sep 29, 2022 in Others by Kithuzzz
 • 38,000 points • 2,213 views
0 votes
1 answer

Sumifs function not recognizing "true" criteria/column

Sep 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,289 views
0 votes
1 answer

Excel: How to take a weighted average where blank values cause proportional weighting shifts

Sep 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,648 views
0 votes
1 answer

How to sum hours and minutes in excel?

Sep 26, 2022 in Others by Kithuzzz
 • 38,000 points • 19,134 views
0 votes
1 answer

Excel - IF Formula with a FIND

Sep 26, 2022 in Others by Kithuzzz
 • 38,000 points • 1,694 views
0 votes
1 answer

Transpose column on one sheet to row on another, with linking

Sep 24, 2022 in Others by Kithuzzz
 • 38,000 points • 2,358 views
0 votes
1 answer

Excel automatically converting 7 digit CAS number to another number (date?)

Sep 24, 2022 in Others by Kithuzzz
 • 38,000 points • 2,270 views
0 votes
1 answer

Extract unique value from the range in Excel

Sep 22, 2022 in Others by Kithuzzz
 • 38,000 points • 2,691 views
0 votes
1 answer

Convert CASE WHEN logic from SQL to EXCEL

Sep 20, 2022 in Others by Kithuzzz
 • 38,000 points • 2,616 views
0 votes
1 answer

Copy the Excel RANK formula without changing the end reference

Jun 8, 2022 in JQuery by Edureka
 • 13,690 points • 2,228 views
0 votes
1 answer

Calculate Growth rate in Excel

Apr 1, 2022 in Database by Edureka
 • 13,690 points • 36,218 views
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

Mar 11, 2022 in Database by Edureka
 • 13,690 points • 3,977 views
0 votes
0 answers

If Cell Starts with Text String... Formula

Feb 24, 2022 in Database by Edureka
 • 13,690 points • 2,287 views
0 votes
1 answer

Excel feet and inches to millimeters

Feb 22, 2022 in Database by Edureka
 • 13,690 points • 3,520 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

Feb 18, 2022 in Others by Edureka
 • 13,690 points • 1,414 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

Feb 18, 2022 in Others by Edureka
 • 13,690 points • 7,223 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

Feb 17, 2022 in Others by Edureka
 • 13,690 points • 1,957 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.