| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
balancing cells on criteria
Hello,
I have the following data: ACC_DAT DIM1 DIM2 DIM3 DIM5 DIM7 JR_NR MONTH REC_AMOUNT BALANCE 010507 9990 15 2000 150 AR30-390 19556 05 90.00 010507 9990 15 2000 190 AR30-390 53339 05 -30.00 010507 9990 15 2000 190 AR30-390 53397 05 -40.00 010507 9990 16 6000 100 AR30-390 53541 05 -10.00 010507 9990 16 6000 190 AR30-395 54072 05 0.01 010507 9990 16 6000 100 AR30-396 56578 05 -50.00 010507 9990 16 6000 190 AR30-396 57076 05 -10.01 010507 9990 16 6000 190 AR30-396 57185 05 60.01 I need a function in column BALANCE that looks if the REC_AMOUNT BALANCES BASED ON DIM7 OR DIM5 OR JR_NR. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| balancing check register | Excel Worksheet Functions | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
