Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mouse over effect on autoshape | Charts and Charting in Excel | |||
Create shadow effect on with chart | Charts and Charting in Excel | |||
return groups of components | Excel Worksheet Functions | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) | |||
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) |