All articles with 'Array Formula' Tag
![Formula Forensics. 009 – Pradhishnair’s Chainage Problem](https://chandoo.org/wp/wp-content/uploads/2012/01/OverlapMaster.png)
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
Continue »![Formula Forensics No. 002 – Joyces Question](https://chandoo.org/wp/wp-content/uploads/2011/11/Joyce_Front.png)
Formula Forensics # 002 – Joyces Question
This is the second post of a new regular weekly series at Chanoo.org, Formula Forensics, where we will examine how a formula works from the inside out with a worked example to help you understand its formation.
Last week we looked at Taruns problem and analysed a formula to solve his problem
This week we look at Joyce’s Problem…
Continue »