calculating based on match critiria

[#1]

Hi guys,

i am facing problem in calculating .. please help me

i have  2 fields   courseid1={1,2,3,4,5,6,13}   count=7

                         courseid2={7,2,3,9,5,12,15}  count=7

these two fields will change dynamically  based on individual employee

when ever  above two fields    contain  {5} as course-id   then i should  include  {2,11,13,16}  in courseid1

  after including  all these courseid's in courseid1   count =9  ( '2' '13' already existed in courseid1 )  so i took distinct here

my final count  of   courseid1=9.

please help how i can resolve this in table level( this cal should be in expression )

Regards

Damodhar

[Gysbert_Wassenaar]

Can you post a document with sample data?