Untitled
Greg
plain_text
6 months ago
647 B
2
Indexable
for each acct open portia transactions file filter as follows: acct (column A) -CASH- (column F) grab column C, D, G, V if D is Buy or Withdrawal, V * -1 add a ' to G, if G is the cash cusip we can remove add to exceptions sheet first available row open bank transactions file filter as follows: acct fund num (column A) Account ends /000 (column F) US DOLLAR (column G) grab column M, N, O, (V or W) (W is negative), AF, AG pair off for each Reams, if BK transaction matches at D and sum of E is <= 0.02, delete the rows
Editor is loading...
Leave a Comment