To be honest, I'm quite confused with your description <g

... to make excel display ALL of the column D values
for the column B constituants. (there would also
be adda, aeea, etc. with A-E and 0 or 1 and then a value.)

If there is one positive (1 is positive 0 is negative) hit for A in
abba and the rest are negative i need excel to display the positve AND
the non positive hits for A in abba, abbc and adda and aeea.

Doesn't the above sound like what you already have/started out with,
i.e. your source table itself ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
wrote in message
oups.com...
It is almost what i am looking for, thanks for the help.
However, when i copy this out i only get clm D values that are 1. I
somehow need to be able to use 1 as a trigger to make excel display ALL
of the column D values for the column B constituants. (there would also
be adda, aeea, etc. with A-E and 0 or 1 and then a value.)

If there is one positive (1 is positive 0 is negative) hit for A in
abba and the rest are negative i need excel to display the positve AND
the non positive hits for A in abba, abbc and adda and aeea.
Thanks again for your help.