Nov 17 2022 08:48 AM
I am trying to create a formula that is essentially (based on dummy data below):
(in cell c2) - if A2 is equal to A3, subtract b3 from b2.
Is this even possible?!
1 | A | B | C |
2 | Joe Bloggs | 100 | |
3 | Joe Bloggs | 95 | |
4 | John Doe | 300 | |
5 | John Doe | 200 | |
6 | John Doe | 200 |
Nov 17 2022 09:09 AM