Hi, I use excel spreadsheet to keep track of my stock position.
I use sort(unique) function to list out all the stock in my stock buy/sell transaction.
So it will automatically list out all the stock that I have buy/sell in the transaction.
But I want to exclude the stock that I have 0 position in my portfolio.
For example,
If you look at stock buy/sell transaction in my excel file, I buy 2 shares of ICE, buy 1 share of BLK, sell 1 share of BLK.
So the open position should be only ICE.
When I use sort(unique) function, it will list out both ICE and BLK.
I want to exclude BLK from the list since I have no more position.
Is there any solution to it?
Thanks in advance.
I use sort(unique) function to list out all the stock in my stock buy/sell transaction.
So it will automatically list out all the stock that I have buy/sell in the transaction.
But I want to exclude the stock that I have 0 position in my portfolio.
For example,
If you look at stock buy/sell transaction in my excel file, I buy 2 shares of ICE, buy 1 share of BLK, sell 1 share of BLK.
So the open position should be only ICE.
When I use sort(unique) function, it will list out both ICE and BLK.
I want to exclude BLK from the list since I have no more position.
Is there any solution to it?
Thanks in advance.