I have a sheet with name "Ole data" in which there are details of subs i.e. subscription and reds i.e. redemption
Now, I want to first identify what are contra entries and what are normal entries
Contra entries means
Where
subs (amount) +reds (amount)=0 and subs (shares) + reds (shares)=0
Once I have identifies above, I want summary of above transactions in "Summary" tab.
There is no specific number of rows i.e. rows can be at a time 10 or it 1000 also.
Sheet is attached for your reference.
Bookmarks