Creating Top 10 List Without Pivot Table
There can be times that you need to create top 10 lists that can be filtered independently from other worksheets along with many other tables...
Beat Excel! Get to next level in Excel!
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...
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...
