-247

552

INDEX() and MATCH() with two criteria.

-7

182

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

65

IF Funtion

-1

291

Count months between two dates

196

190

How to sum bottom n values in Excel.

119

search function

114

Using SUMPRODUCT to sum against various criteria

85

Using COUNTIF() to count values greater than a criteria

0

584

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

418

Understanding INDIRECT() formula in MS Excel

242

Calculate the number of months between two dates

204

Getting only non-blank cell when checking for a crtieria

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

Find the two characters representing US City in a string

179

Rank on Filtered List

166

Calculate how many days between two dates

162

Using INDIRECT() function to read cell addresses and return corresponding values.

160

Get anything to the left of first space or underscore

159

Find the difference between two dates

1

90

How to sum values with multiple OR criteria.

53

Calculate Friday's between two dates

80

124

How to use NETWORDAYS() in excel

97

Using NETWORKDAYS formula

83

Using NETWORKDAYS() in MS Excel

87

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

103

How to use SUMPRODUCT function to validate a criteria and sum

95

110

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

142

Using SUMPRODUCT() function to sum ranges.

Using HLOOKUP() function to retrieve values in tables.

INDEX() and MATCH() with two criteria.