Rank by Multiple Criteria in Excel
Here we look at a formula that will automatically sort a data set by two or more text fields. Ideal for outputting names and departments into alphabetical order.
Month: June 2015
Why INDEX-MATCH is better than VLOOKUP
Here we look at the many uses of the INDEX(MATCH()) combo formula, and why it is a superior replacement for the commonly-used VLOOKUP() and HLOOKUP() functions.