Excel Tips

Formula Solutions

  • Find Closest Values in an Array
  • Multiple Criteria V-lookups
  • Using Index/Match for Salary Increase Guidelines
  • Median Ifs
  • How to Calculate Payouts based on Performance

VBA solutions

  • Creating Multiple Tabs Based on a Cell’s Value
  • Password Protecting Individual Tabs
  • Saving Tabs as New Workbooks

Miscellaneous Solutions

  • How to Create a Chart for Grade Ranges