Hi all,
I hope everyone is well.
I'm an acountant by trade, so you'd never assume i'm an excel rookie, however, that is the case unfortunately.
Does anyone know a formula that can spot all values in a row that net to 0. For E.G, an entry of 100 matches with another entry of -100.
Or another example would be, one entry that is 200, but that is netted off by two seperate journals of -100.
Many thanks.
I hope everyone is well.
I'm an acountant by trade, so you'd never assume i'm an excel rookie, however, that is the case unfortunately.
Does anyone know a formula that can spot all values in a row that net to 0. For E.G, an entry of 100 matches with another entry of -100.
Or another example would be, one entry that is 200, but that is netted off by two seperate journals of -100.
Many thanks.