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
Example
Case I
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
Result would be Contra Entries, as similar shares in subs i.e. 10 is there in reds with amount also same.
Case II-
1. Subs Shares 10 Amount 100
2. Reds Shares -11 Amount 100
Result would be normal entry as shares are different.
Case III-
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
3. Subs Shares 10 Amount 100
Result would be Contra Entries for 1 and 2, as similar shares in subs i.e. 10 is there in reds with amount also same.
Result would be normal entry for 3 as I don't have any 4th entry for which shares and amount are same except for which sign would be different.
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
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
Example
Case I
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
Result would be Contra Entries, as similar shares in subs i.e. 10 is there in reds with amount also same.
Case II-
1. Subs Shares 10 Amount 100
2. Reds Shares -11 Amount 100
Result would be normal entry as shares are different.
Case III-
1. Subs Shares 10 Amount 100
2. Reds Shares -10 Amount 100
3. Subs Shares 10 Amount 100
Result would be Contra Entries for 1 and 2, as similar shares in subs i.e. 10 is there in reds with amount also same.
Result would be normal entry for 3 as I don't have any 4th entry for which shares and amount are same except for which sign would be different.
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