Recent questions tagged excel-formula

0 votes
1 answer

Excel date format mismatch

Oct 30, 2022 in Others by Kithuzzz
 • 33,140 points • 276 views
0 votes
1 answer

Find occurrence count of a number in Excel

Oct 30, 2022 in Others by Kithuzzz
 • 33,140 points • 149 views
0 votes
1 answer

How to export data with functions to another workbook in excel

Oct 30, 2022 in Others by Kithuzzz
 • 33,140 points • 100 views
0 votes
1 answer

How can I sort one set of data to match another set of data in Excel?

Oct 29, 2022 in Others by Kithuzzz
 • 33,140 points • 165 views
0 votes
1 answer

Shortcut to Apply a Formula to an Entire Column in Excel

Oct 29, 2022 in Others by Kithuzzz
 • 33,140 points • 102 views
0 votes
1 answer

Currency conversion:number to words excel

Oct 28, 2022 in Others by Kithuzzz
 • 33,140 points • 106 views
0 votes
1 answer

Auto fill in the blanks in Excel

Oct 27, 2022 in Others by Kithuzzz
 • 33,140 points • 203 views
0 votes
1 answer

Ignore text values in subtotal function

Oct 24, 2022 in Others by Kithuzzz
 • 33,140 points • 133 views
0 votes
1 answer

Using Excel Proper Function with exception | Excel

Oct 21, 2022 in Others by Kithuzzz
 • 33,140 points • 124 views
0 votes
1 answer

Excel - IFERROR Function

Oct 20, 2022 in Others by Kithuzzz
 • 33,140 points • 109 views
0 votes
1 answer

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

Oct 16, 2022 in Others by Kithuzzz
 • 33,140 points • 220 views
0 votes
1 answer

Amortization schedule for many rows using Excel Macro

Oct 16, 2022 in Others by Kithuzzz
 • 33,140 points • 153 views
0 votes
1 answer

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

Oct 16, 2022 in Others by Kithuzzz
 • 33,140 points • 432 views
0 votes
1 answer

Convert three letter country codes to full country names

Oct 16, 2022 in Others by Kithuzzz
 • 33,140 points • 108 views
0 votes
1 answer

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

Oct 15, 2022 in Others by Kithuzzz
 • 33,140 points • 138 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
 • 33,140 points • 364 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
 • 33,140 points • 184 views
0 votes
1 answer

Converting Feet-Inches to Inches Excel

Oct 15, 2022 in Others by Kithuzzz
 • 33,140 points • 252 views
0 votes
1 answer

Insert pie chart in Excel macro function

Oct 14, 2022 in Others by Kithuzzz
 • 33,140 points • 384 views
0 votes
1 answer

How to split text values by a delimiter?

Oct 11, 2022 in Others by Kithuzzz
 • 33,140 points • 180 views
0 votes
1 answer

Absolute worksheet reference in excel cell formulas

Oct 10, 2022 in Others by Kithuzzz
 • 33,140 points • 164 views
0 votes
1 answer

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

Oct 10, 2022 in Others by Kithuzzz
 • 33,140 points • 176 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
 • 33,140 points • 162 views
0 votes
1 answer

Excel - compound interest with continuing contribution

Oct 7, 2022 in Others by Kithuzzz
 • 33,140 points • 119 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Oct 7, 2022 in Others by Kithuzzz
 • 33,140 points • 216 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

Oct 7, 2022 in Others by Kithuzzz
 • 33,140 points • 389 views
0 votes
1 answer

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

Oct 3, 2022 in Others by Kithuzzz
 • 33,140 points • 176 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Oct 3, 2022 in Others by Kithuzzz
 • 33,140 points • 302 views
0 votes
1 answer

Excel Formula Query on Summing Annual Leave Days and Half Days

Oct 3, 2022 in Others by Kithuzzz
 • 33,140 points • 321 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Oct 3, 2022 in Others by Kithuzzz
 • 33,140 points • 475 views
0 votes
1 answer

Calculate age in excel

Oct 2, 2022 in Others by Kithuzzz
 • 33,140 points • 108 views
0 votes
1 answer

Moving Average formula in Excel not autofilling in table

Oct 1, 2022 in Others by Kithuzzz
 • 33,140 points • 179 views
0 votes
1 answer

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

Sep 30, 2022 in Others by Kithuzzz
 • 33,140 points • 184 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
 • 33,140 points • 220 views
0 votes
1 answer

Goal Seek in Excel

Sep 29, 2022 in Others by Kithuzzz
 • 33,140 points • 215 views
0 votes
1 answer

Using Excel VLOOKUP() function across two sheets

Sep 29, 2022 in Others by Kithuzzz
 • 33,140 points • 235 views
0 votes
1 answer

Sumifs function not recognizing "true" criteria/column

Sep 27, 2022 in Others by Kithuzzz
 • 33,140 points • 129 views
0 votes
1 answer

How to sum time in Excel?

Sep 26, 2022 in Others by Kithuzzz
 • 33,140 points • 329 views
0 votes
1 answer

Excel - IF Formula with a FIND

Sep 26, 2022 in Others by Kithuzzz
 • 33,140 points • 194 views
0 votes
1 answer

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

Sep 24, 2022 in Others by Kithuzzz
 • 33,140 points • 207 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.