-123

410

INDEX() and MATCH() with two criteria.

-1

244

Count months between two dates

150

How to sum bottom n values in Excel.

120

106

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

87

search function

84

Using SUMPRODUCT to sum against various criteria

0

368

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

285

Understanding INDIRECT() formula in MS Excel

200

Calculate the number of months between two dates

178

Getting only non-blank cell when checking for a crtieria

161

Find the two characters representing US City in a string

146

Rank on Filtered List

140

Calculate how many days between two dates

138

Get anything to the left of first space or underscore

134

Get days between two dates excluding start date

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

124

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

122

How to calculate days between two dates

121

Find the difference between two dates

1

51

How to sum values with multiple OR criteria.

33

Calculate Friday's between two dates

55

96

How to use NETWORDAYS() in excel

74

Using NETWORKDAYS formula

63

Using NETWORKDAYS() in MS Excel

66

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

69

How to use SUMPRODUCT function to validate a criteria and sum

85

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

98

Using SUMPRODUCT() function to sum ranges.

76

Using HLOOKUP() function to retrieve values in tables.

82

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

INDEX() and MATCH() with two criteria.