All articles with 'Array Formula' Tag
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 valuesContinue »
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 »