Finding nth Largest or Smallest Value in an Array
When you need to find second largest value or third smallest value in an array of cells, you can do it easily with LARGE() and...
Beat Excel! Get to next level in Excel!
Finding 2nd Matching Value with Vlookup
There can be times that you need to look up for a value but not necessarily want the first matching value. Vlookup function cannot help...
Personal Expenses Manager 2
Here is another personal expenses manager is available for download. Be aware of your monthly and annual finances all the time with Personal Expenses Manager...
Line Chart with Arrow
You can add an arrow at the end of your line charts to better emphasize trend. Creating a line chart with arrow is no different...
Excel Solver Example
Let Excel solve problems for you! I recently used Excel for comparing two alternatives. Then I decided to construct an Excel Solver example for you...
Enable Solver in Excel
This post details how to enable solver in Excel. Solver is an add-in for Excel that solves optimization problems for you. All you need to...
