Recent questions tagged excel-formula

0 votes
1 answer

Why percentage calculation in excel gives me incorrect numbers

Dec 11, 2022 in Others by Kithuzzz
 • 38,000 points • 2,542 views
0 votes
1 answer

Check whether a cell contains a substring

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

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

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

How to remove values from drop-down if value deleted from validation list

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

Excel Formula which places date/time in cell when data is entered in another cell in the same row

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

Excel Formula: Count cells where value is date

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

Excel Count if with index match

Dec 9, 2022 in Others by Kithuzzz
 • 38,000 points • 3,088 views
0 votes
1 answer

"Advance" an Excel formula via keyboard shortcut while in edit mode?

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

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

Nov 29, 2022 in Others by Kithuzzz
 • 38,000 points • 1,939 views
0 votes
0 answers

Conditional statement (truth table) formula on Excel

Nov 27, 2022 in Others by Kithuzzz
 • 38,000 points • 1,649 views
0 votes
0 answers

In Excel Sheet how to Eliminate or Remove, Filter and copy the selected records defined in another sheet using dynamic array list (VBA Module)

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

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

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,372 views
0 votes
1 answer

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

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

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

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,392 views
0 votes
1 answer

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

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 4,753 views
0 votes
1 answer

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

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 3,343 views
0 votes
1 answer

Countifs formula using weekday function

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

How to simplify adding multiple countifs formula in excel

Nov 26, 2022 in Others by Kithuzzz
 • 38,000 points • 2,036 views
0 votes
1 answer

Concatenate columns using LEFT and RIGHT in EXCEL

Nov 25, 2022 in Others by Kithuzzz
 • 38,000 points • 1,552 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

Nov 25, 2022 in Others by Kithuzzz
 • 38,000 points • 2,598 views
0 votes
1 answer

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

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

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

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 3,205 views
0 votes
1 answer

How can i add cells if condition is met

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

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

Nov 24, 2022 in Others by Kithuzzz
 • 38,000 points • 3,384 views
0 votes
1 answer

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

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,749 views
0 votes
1 answer

Using "If cell contains #N/A" as a formula condition.

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,527 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 2,423 views
0 votes
1 answer

Cell character counting formula?

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,455 views
0 votes
1 answer

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

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 2,133 views
0 votes
1 answer

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

Nov 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,637 views
0 votes
1 answer

Excel: Cross-sheet reference not working

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 11,508 views
0 votes
1 answer

Return empty cell from formula in Excel

Nov 20, 2022 in Others by Kithuzzz
 • 38,000 points • 9,040 views
0 votes
1 answer

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

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

Pass multiple Excel cell values to Power Automate

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

Excel SUMIFS() using string with greater/less than symbols

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

Camel case converter in an excel

Nov 19, 2022 in Others by Kithuzzz
 • 38,000 points • 6,487 views
0 votes
1 answer

How to merge columns in Excel but keep data on other columns

Nov 19, 2022 in Others by Kithuzzz
 • 38,000 points • 2,047 views
0 votes
1 answer

Is it possible to round to different decimal places in excel based on the range?

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

Excel MATCH function is not working on an array but works once directed to the matched value

Nov 17, 2022 in Others by Kithuzzz
 • 38,000 points • 2,340 views
0 votes
1 answer

Count cells in excel with populated values

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

Showing percentages above bars on Excel column graph

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

Excel - IF combined with Index Match

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

Excel is not updating cells, options > formula > workbook calculation set to automatic

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

Reversing Text to Columns in Excel/Calc

Nov 15, 2022 in Others by Kithuzzz
 • 38,000 points • 1,789 views
0 votes
1 answer

MAX function in Excel: is it possible to provide the range by means of variables?

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

Excel remaining days count from today until due date minus weekends?

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

Extract Uppercase Words on Excel

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

Is there a function in excel to find duplicates

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

Avoiding index & match #N/A value

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

Excel formula to average selected cells based on certain criteria

Nov 13, 2022 in Others by Kithuzzz
 • 38,000 points • 1,581 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.