Last week I set readers the challenge which can be found here.
This one turns out to be a good deal more complex than it at first appears, and so perhaps not surprisingly no correct results were received..
GreasySpot at first thought that Advanced Filter would be a viable solution, but quickly realised that it wasn’t actually appropriate here. Besides, as I mentioned, the idea of this (and of all these challenges in fact) is to try to achieve the results using worksheet formulas alone.
So how can we achieve our desired results?
More…