A clever technique to simplify your long, nested IF formulas
Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.
Formula Forensics 043: Rankifs or Conditional Rank
Learn how to develop a Conditional Rank or Rankifs formula in Excel
Formula Forensics 042: Reverse Text – A Formulaic Solution
Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.
Formula Forensics No. 041 – Convert a Roman Numeral to a Number
Learn how to convert a Roman Numeral to a Number using this nifty formula. No VBA required.
Formula Forensics 040 – Apportioning Sales by Criteria
Lets look at how to apportion sales according to multiple criteria
Formula Forensics No. 039 – Find the Cell Address for a value (2D & 3D Reverse Lookup)
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
Formula Forensics No. 038 – Find Which Worksheet a Max or Min Value is located on
Learn how to find which worksheet a max or min value occurs on using this neat formula