Formula Forensic 014 – Faseeh’s Formula
“I have a large list which includes blanks, I want to retrieve the list without the blanks”
Faseeh, responded with a neat array formula.
Today Formula Forensics pulls Faseeh’s Formula apart to see what makes it tick.
Formula Forensics 013. – On Vacation
Formula Forensics is on Vacation.
Formula Forensics is actually on a working Holiday and has visited the Excel Hero Academy this week.
So today in Formula Forensics we will showcase some of the work that have been derived from the learning’s at the Excel Hero Academy.
Formula Forensics 012. – A Neat Formula
;
Today we look at a very neat way of doing a complex Nested If or Vlookup style problem with a simple but beautiful Sumproduct based formula.
Formula Forensics 011. Lykes Formula
Lykes asked Formula Forensics “How does a formula work?” Lykes has been using the formula without understanding it.
The formula counts how many times the letters from a list of letters occur in a list of words.
Today we look at a Lykes question.
Formula Forensics No. 010 Count How Many Times a List of Values Occurs in a Range
Count How Many Times a List of Values Occurs in a Range
(or How Can I Simplify My Formula)
Today in Formula Forensics we look at how to count how many times a range of values occurs within a Range of cells and in the process simplify a very nasty formula.
Formula Forensics No. 008 – Elkhan’s MaxIf
Today in Formula Forensics we look at how to Calculate the Maximum value from a list subject to other fields meeting certain criteria:
Formula Forensics. 009 – Pradhishnair’s Chainage Problem
A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?
This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values