I need a drink...or several!
Thanks, k0. userque's formula did the trick. I ended up needing one other change that I didn't account for originally, but your solution would have done it too. This was the final result:
2 columns, delete any name in column A if it was in column B. Or column C = (column A minus column B).
Thanks everyone, for your help!!=IF(A2<>"",IFERROR(IF(MATCH(A2,OFFSET($B$1,0,0,100 ,1),0),"",A2 ),A2),"")
Tom
Market Commentary | My Blog | TSP Talk Plus | |
I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.
I need a drink...or several!
Good, I have few of these I'd like to redeem.
onedrinkticket.jpg
out where i live we call them 'wooden nickels' they are free drink tokens like a poker chip and you can get them at any bar/community center. the pool table gives the young kids something to do while the adults discuss 'business' at the long desk with a mirror behind it.
Attachment 34229
i.would show you a real one from my collection, but i seemed to have used them all.
100g
S&P500 (C Fund) (delayed) (Stockcharts.com Real-time) |
DWCPF (S Fund) (delayed) (Stockcharts.com Real-time) |
EFA (I Fund) (delayed) (Stockcharts.com Real-time) |
BND (F Fund) (delayed) (Stockcharts.com Real-time) |
||
Yahoo Finance Realtime TSP Fund Tracking Index Quotes |
Bookmarks