Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with group formula criteria
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 | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
How do I set up a formula with multiple criteria? | Excel Worksheet Functions | |||
formula that meets two criteria and sums? | Excel Discussion (Misc queries) | |||
Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |