"roy.okinawa" wrote
OK. It works fine while in the test.xls.
However, when I enter the formula
in the overall.xls it still comes up with repeats ..

No reason, imo, why it should work only in the 1st test file, which
presumably was already a "prime" cut / subset of your actual. Could you
upload another similar file with the revised formulas loaded and with the
repeats still showing, as you say above ? That's the best way to diagnose.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--