#1
|
|||
|
|||
Formula Help
I am trying to take an employees number and balances subtype to subtract the balance for that subtype from the next line.
For example: Employee Name Subtype Units Used Employee A 25 1040 0 Employee A 30 240 0 Employee A 30 220 20 Employee A 30 210 10 Employee B 25 1040 0 Employee B 30 240 0 Employee B 30 200 40 The data stacks and I want to be able use the employee's name, then look at the subtype "30" and subtract from the previous line. |
#2
|
||||
|
||||
Hi
please post a sample sheet showing what you want to achieve. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Example
I want the formula to look at the employee, then and the type to be able to subtract the number colulmn.
|
#4
|
|||
|
|||
Try this in F2 and copy down.
=IF(AND(A1=A2,B1=B2),C1-C2,0) Good Luck!!! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Help | OTPM | Excel | 5 | 02-21-2013 08:03 AM |
formula help | excelledsoftware | Excel | 8 | 03-25-2012 08:49 AM |
help with formula? | doczilla | Excel | 2 | 09-25-2011 04:14 PM |
Help with formula please. | AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
If formula | sixhobbits | Excel | 1 | 10-02-2009 08:02 AM |