Forum Discussion
formula help for this dataset?
- Get the total of each unique "code" in "C" column by subtracting the non total numbers in column F.
Please see a demo sheet here with example of me done it manually for 2 cells.
One can see the demo sheet here
Can you help with the formula for excel?
7 Replies
HansVogelaar . Its the way the calculation needs to be done .... Depending on the Column "C"... if you look at Column C, there are numbers /codes, For each code I need to know the total in the the row situated in column I , but sometimes there these codes appear more than once (2 times mostly), so I cant total duplicates, I need to subtract the duplicate looking at column E if there is a variable named 09: 500+ Employees & then get the total in Column I in the same row
Does this make sense to you??
No, I don't understand why you subtract a value from column G in one case and from column F in another.
