Page 1 of 3 123 LastLast
Results 1 to 12 of 29

Thread: Excel expert needed

  1. #1

    Default Excel expert needed

    I need some help with an Excel issue.

    I have a spreadsheet with two columns, A & B.

    I want to combine the columns into a column C and completely remove anything that shows up in both A & B. Not just remove the duplicates, but delete that entry completely.

    A
    B
    C
    Bob Bill Bill
    Mary Bob Peggy
    Peggy Mary

    Any idea? Thank you!
    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. #2

    Default Re: Excel expert needed

    Do you want column c to show bob bill?
    if so, , put =sign in column c ,like
    = a" "&" "b
    a is cell a and b is cell b
    sorry, we don't have power due to tornado and I am just using my cell phone. I could give better instructions once power is back. Best I can do under this condition.
    Emotions should never play a role in one's investing strategy!
    No to Greed...No to Fear!
    http://share.robinhood.com/mariloc1

  4.  
  5. #3

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

    Default Re: Excel expert needed

    Do you want to delete column a and b where c becomes a or do you want column a and be to remain but only blank?
    This is too easy. What am I missing? You don't need an expert for this.

  6.  
  7. #4

    Default Re: Excel expert needed

    I have A & B and I want to create the C column. If a value is in both A & B columns, I don't want them at all in C.

    I don't care what happens to column A and B. I will take C and do something with it.

    So here I am trying to come up with a list (C) that deletes Bob and Mary because they are in both columns A & B.



    I hope that makes sense.

    I see where you are going Maricar19. I'll explore that.

    Thanks!
    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.

  8.  
  9. #5

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Excel expert needed

    Quote Originally Posted by tsptalk View Post
    I need some help with an Excel issue.

    I have a spreadsheet with two columns, A & B.

    I want to combine the columns into a column C and completely remove anything that shows up in both A & B. Not just remove the duplicates, but delete that entry completely.

    A
    B
    C
    Bob Bill Bill
    Mary Bob Peggy
    Peggy Mary

    Any idea? Thank you!
    Without using VBA, this can be done quickly, but you'll have to use the excel feature to remove the blank cells afterward:

    A
    B
    C
    Bob Bill Bill
    Mary Bob [blank]
    Peggy Mary Peggy

    Remove Empty Cells in Excel 2007 or 2010 Spreadsheets

    Post wether that's OK, then I'll generate and post the formulas you need.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  10.  
  11. #6

    Default Re: Excel expert needed

    Blanks are fine. Thanks.

    Just to make sure, here's a larger example just dropping Mary, the only duplicate.

    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.

  12.  
  13. #7

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Excel expert needed

    Quote Originally Posted by tsptalk View Post
    Blanks are fine. Thanks.

    Just to make sure, here's a larger example just dropping Mary, the only duplicate.

    Got it. Is the order of column C important at this stage?
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  14.  
  15. #8

    Default Re: Excel expert needed

    Quote Originally Posted by userque View Post
    Got it. Is the order of column C important at this stage?
    Not at all. TY!
    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.

  16.  
  17. #9

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Excel expert needed

    Quote Originally Posted by tsptalk View Post
    Not at all. TY!
    no problem.

    Final check:

    You will get two columns as output, C & D, along with the blanks. You would have to copy and paste (blanks and all) one of those columns (just the data, not the whole column) somewhere underneath the last entry of the other to make one longer column--including blanks. Then you would remove the blanks as discussed.

    If this is ok, I can began.

    (Forgive all the questions...I find it's best to be very clear with Excel projects
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]


  18.  
  19. #10

    Default Re: Excel expert needed

    i'm just glad "burrocrat" doesn't show up in either column a or column b at this point, yet.
    100g

  20.  
  21. #11

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Default Re: Excel expert needed

    If someone doesn't solve this (don't want to parallel path a solution), PM me and I will check the thread out. I am pretty handy with Excel too. Thanks!!
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  22.  
  23. #12

    Default Re: Excel expert needed

    That will work. Thanks!

    Quote Originally Posted by userque View Post
    no problem.

    Final check:

    You will get two columns as output, C & D, along with the blanks. You would have to copy and paste (blanks and all) one of those columns (just the data, not the whole column) somewhere underneath the last entry of the other to make one longer column--including blanks. Then you would remove the blanks as discussed.

    If this is ok, I can began.

    (Forgive all the questions...I find it's best to be very clear with Excel projects
    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.

  24.  
Page 1 of 3 123 LastLast

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