J
jamie_moore
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
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