help in using count if,,

Giganews Newsgroups
Subject: help in using count if,,
Posted by:  Kent - Tech Evangelist
Date: Wed, 31 May 2006

if a have two set of tables in two different sheets,,

i.e.

session1 - Table1(sheet1)
email                    Attend
tes…@msn.com    yes
tes…@msn.com    yes
tes…@msn.com    no

session2 - Table2(sheet2)
email                    Attend
tes…@msn.com    no
tes…@msn.com    yes
tes…@msn.com    no

can i create a new table at a new sheet showing me who didnt attend the two
sessions,,

help will be highly appreciated,,

Replies