... Roger Govier also posted an alternative using Pivot Tables (w/o
any formulae), in his response to a similar query recently:
http://tinyurl.com/ddutm

(Roger's sample file in the cjoint link therein has expired since ..

Managed to locate my d/l of Roger's sample ..

Here's a fresh link to Roger's sample, for those interested:
http://www.savefile.com/files/1939101
Auto-Filter Data To Resp Sheet_Pivot Table Approach_RogerGovier.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---