Page 3 of 3 FirstFirst 123
Results 25 to 29 of 29

Thread: Excel expert needed

  1. #25

    Default Re: Excel expert needed

    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).

    =IF(A2<>"",IFERROR(IF(MATCH(A2,OFFSET($B$1,0,0,100 ,1),0),"",A2 ),A2),"")
    Thanks everyone, for your help!!
    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.

  2.  
  3. #26

    Join Date
    Aug 2008
    Location
    Pensacola, FL
    Posts
    6,312

    Default Re: Excel expert needed

    I need a drink...or several!

  4.  
  5. #27

    Default Re: Excel expert needed

    Quote Originally Posted by jpcavin View Post
    I need a drink...or several!
    perfect timing, i was just gonna ask if i could get you one?
    100g


  6.  
  7. #28

    Join Date
    Aug 2008
    Location
    Pensacola, FL
    Posts
    6,312

    Default Re: Excel expert needed

    Quote Originally Posted by burrocrat View Post
    perfect timing, i was just gonna ask if i could get you one?
    Good, I have few of these I'd like to redeem.

    onedrinkticket.jpg

  8.  
  9. #29

    Default Re: Excel expert needed

    Quote Originally Posted by jpcavin View Post
    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

  10.  
Page 3 of 3 FirstFirst 123

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Excel expert needed
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Excel expert needed
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Excel expert needed
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Excel expert needed
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes