Returning only non zero effect groups
 

Here is a sample list (mine are much larger w/many more fields)

Name Amount Date

bob 100 04-05-05
bob -50 05-04-05
bob -25 05-05-05
sarah 200 04-03-05
sarah -200 04-06-05
dave 300 04-02-05
dave -150 04-27-05
dave -150 05-18-05

I only care about the values for the groups(name would be group in this
case) in which the net effect of all amounts IS NOT zero. I need all the
data in every field when that is the case. I am willing to put it in a
Access table if necessary, but would rather do it in excel. Obviously with a
lot of data it would be very inefficient to Subtotal and then manually delete
those that have a net zero effect.

Thanks for any help
--
jamie

try a helper column with
=if(sumif($A$1:$A$1000,B1,$C$1:$C$1000)=100,0,1)
then select the helper column <data<filters<Autofilter
goto the little arrow at the top of the helper column and select 1
this now shows the names whose data does not = 100

"jamie_moore" wrote:

Here is a sample list (mine are much larger w/many more fields)

Name Amount Date

bob 100 04-05-05
bob -50 05-04-05
bob -25 05-05-05
sarah 200 04-03-05
sarah -200 04-06-05
dave 300 04-02-05
dave -150 04-27-05
dave -150 05-18-05

I only care about the values for the groups(name would be group in this
case) in which the net effect of all amounts IS NOT zero. I need all the
data in every field when that is the case. I am willing to put it in a
Access table if necessary, but would rather do it in excel. Obviously with a
lot of data it would be very inefficient to Subtotal and then manually delete
those that have a net zero effect.

Thanks for any help
--
jamie