-31

288

INDEX() and MATCH() with two criteria.

-1

194

Count months between two dates

120

How to sum bottom n values in Excel.

58

search function

55

Using SUMPRODUCT to sum against various criteria

38

0

149

Getting only non-blank cell when checking for a crtieria

136

Calculate the number of months between two dates

125

Find the two characters representing US City in a string

117

Get anything to the left of first space or underscore

115

Rank on Filtered List

110

Get days between two dates excluding start date

107

Checking if a date is maximum for all dates for the same month

103

Calculate how many days between two dates

98

How to calculate days between two dates

93

Using Sumproduct function for multiple criteria sum

87

Find the difference between two dates

How to retrieve values with only "Yes" in column next to it.

Two tier tax calculation

78

Find how many days between 2 dates

7

Calculate Friday's between two dates

1

36

69

How to use NETWORDAYS() in excel

52

Using NETWORKDAYS formula

42

Using NETWORKDAYS() in MS Excel

45

How to use NETWORKDAYS.INTL() in MS Excel 2010.

How to use SUMPRODUCT function to validate a criteria and sum

47

49

How to use SUMPRODUCT() to sum against a criteria.

Using SUMPRODUCT() function to sum ranges.

61

How to use LOOKUP() function to look for values.

44

Using HLOOKUP() function to retrieve values in tables.

How to use MS Excel's ADDRESS() function to set cell addresses

64

Use MS Excel's CELL() formula to find the address of a cell

57

Understanding INDIRECT() formula in MS Excel

53

Using INDIRECT() excel function to read R1C1 type cell references.

How to read R1C1 style referencing with INDIRECT() function

INDEX() and MATCH() with two criteria.