Hey, hoping someone will be able to help me with some complex logic I'm struggling with.. ?
Please see below screenshot, I'm working on a database that has the following logic. If transaction edited, new lines created to reverse original transaction, final lines created for final transaction, for these edits, the source ID will remain the same but journal number will grow. Therefore, I can easily identify the last journal number to a source ID by using the maxifs formula. But, I only need the odd amount of instances to show. E.g. where a source ID is only linked to a count of 1,3,5,7.... journal numbers. As if it is an even amount, it is just voiding/deleting the transaction.
To clarify, in the below scenario I only want to show the journal number 5,317. But, if this line didn't exist (was only 71, and 5,316), I wouldn't want to show any. Hope this helps!
Please see below screenshot, I'm working on a database that has the following logic. If transaction edited, new lines created to reverse original transaction, final lines created for final transaction, for these edits, the source ID will remain the same but journal number will grow. Therefore, I can easily identify the last journal number to a source ID by using the maxifs formula. But, I only need the odd amount of instances to show. E.g. where a source ID is only linked to a count of 1,3,5,7.... journal numbers. As if it is an even amount, it is just voiding/deleting the transaction.
To clarify, in the below scenario I only want to show the journal number 5,317. But, if this line didn't exist (was only 71, and 5,316), I wouldn't want to show any. Hope this helps!