Recent questions tagged excel-formula

0 votes
1 answer

Determine if calculation between 2 date time values is < 72 Hours in excel

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

Using standard deviation function in excel for a specific criteria?

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

=CONCATENATE() function giving a #VALUE! error (EXCEL 2013)

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

Calculate Monthly Highest Selling Product - MS Excel

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

Multiple IF statements in Excel not working

Nov 12, 2022 in Mobile Development by Kithuzzz
 • 38,000 points • 1,779 views
0 votes
1 answer

Excel sumif function with conditions

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

Rename Excel worksheets from range

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

Use Excel pivot table as data source for another Pivot Table

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

Control cell value from another cell in Excel

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

Want Tick mark and X-mark using current date and current time using Excel formula

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

Alternatives to Subtotal function in excel

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

Excel formula: Correct syntax of SUM with ROW?

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

Obtaining Excel worksheet reference by worksheet name via C#

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

Create Drop-Down List Using a Formula (Without Data Validation)

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

Calculate slope and intercept value for logarithmic trendline as excel

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

How to multiply by a percentage range in Excel

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

Excels INDEX with MATCH for multiple criteria

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 1,867 views
0 votes
1 answer

Excel get percentage of difference between numbers?

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 1,788 views
0 votes
1 answer

Understanding How Excel Processes Array Functions

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 1,303 views
0 votes
1 answer

Logical calculation in Excel

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 1,795 views
0 votes
1 answer

Copy the Excel RANK formula without changing the end reference

Nov 7, 2022 in Others by gaurav
 • 25,250 points • 1,696 views
0 votes
1 answer

(Excel) If cell is greater than <condition> then minus <number>

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

Excel formula that combines MATCH, INDEX and OFFSET

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

How do I combine the first character of a cell with another cell in Excel?

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

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

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

How to format numbers in excel in crores or lacks

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

Excel TRIM Function Bug

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

Using VLOOKUP()

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

Excel formula gives error when write using Apache-poi library in Java

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

Excel issue "excel 4.0 function stored in defined names"

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

Excel Formula - if values in columns all contain X then return

Nov 3, 2022 in Others by Kithuzzz
 • 38,000 points • 3,013 views
0 votes
0 answers

Converting feet & inches (e.g., "5 ft 1 in") to decimal feet using VBA or Excel

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

What is the formula to keep first two words in a cell over excel?

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

Excel formula converting tan to angle

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 1,306 views
0 votes
0 answers

How to create DropDown which have dynamic Validation List

Oct 31, 2022 in Others by Kithuzzz
 • 38,000 points • 1,384 views
0 votes
0 answers

EXCEL - SUMIF for multiple sheets

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

Excel Formula multiple Index Match and Average the result

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

Frequency Array formula EXCEL not calculating

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

Excel dashboard using slicers when cell contains multiple values

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

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

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

Excel date format mismatch

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

Find occurrence count of a number in Excel

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

How to export data with functions to another workbook in excel

Oct 30, 2022 in Others by Kithuzzz
 • 38,000 points • 1,702 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
 • 38,000 points • 3,740 views
0 votes
1 answer

Shortcut to Apply a Formula to an Entire Column in Excel

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

How to categorize/classify numbers from different ranges using Excel?

Oct 28, 2022 in Others by Kithuzzz
 • 38,000 points • 5,837 views
0 votes
1 answer

Currency conversion:number to words excel

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

Auto fill in the blanks in Excel

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

Ignore text values in subtotal function

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

Using Excel Proper Function with exception | Excel

Oct 21, 2022 in Others by Kithuzzz
 • 38,000 points • 1,723 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.