Any Excel Gurus in here?

Discussion in 'The Bar' started by Stan Beeman, Apr 29, 2014.

  1. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
    I need some help...
     
  2. Oderus

    Oderus Going to hell VIP

    Reputations:
    121,809
    Joined:
    Aug 21, 2012
    Messages:
    55,692
    Likes Received:
    3,708
    what are you trying to do?
     
  3. Kanye West

    Kanye West Yeezus!

    Reputations:
    31,875
    Joined:
    Dec 23, 2011
    Messages:
    115,550
    Likes Received:
    20,524
    RIP Guru

    [​IMG]
     
  4. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,068
    Joined:
    Sep 23, 2010
    Messages:
    42,903
    Likes Received:
    15,337

    RIP :fail:
     
  5. BrulesRules

    BrulesRules Just grab 'em in the biscuits Gold

    Reputations:
    347,913
    Joined:
    Jan 18, 2012
    Messages:
    133,474
    Likes Received:
    60,158
    I'm fluent in excel but wouldn't call myself a guru.
     
  6. BrulesRules

    BrulesRules Just grab 'em in the biscuits Gold

    Reputations:
    347,913
    Joined:
    Jan 18, 2012
    Messages:
    133,474
    Likes Received:
    60,158
    plus anything you don't know how to do you just look up on google and can figure it out.
     
  7. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
    I need something like this...

    If an email address in column B, matches an email in (another tab in same worksheet, column B), replace that cell with (2nd tab of worksheet, column C, that was the match to the column B, same row).
     
  8. Kanye West

    Kanye West Yeezus!

    Reputations:
    31,875
    Joined:
    Dec 23, 2011
    Messages:
    115,550
    Likes Received:
    20,524
    :wtf:
     
  9. Divorce Chicken

    Divorce Chicken white punk on dope VIP

    Reputations:
    139,043
    Joined:
    Jan 24, 2012
    Messages:
    14,115
    Likes Received:
    31,196
    TIP: * = x
     
  10. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,068
    Joined:
    Sep 23, 2010
    Messages:
    42,903
    Likes Received:
    15,337
    This is exactly why I didn't respond. I figured it must be some big ass problem if he didn't google it.

    Cmon Booger, tell us what it is.
     
  11. Lou Loomis

    Lou Loomis Feel the Gern

    Reputations:
    56,402
    Joined:
    Aug 7, 2012
    Messages:
    17,244
    Likes Received:
    9,716
    [video=youtube;3QB74T4YGgo]http://www.youtube.com/watch?v=3QB74T4YGgo[/video]
     
  12. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
    maybe an example would help...

    All in same worksheet.
    Worksheet 1 = email addresses
    Worksheet 2 = email addresses with first and last name

    I need the last names on Worksheet 2 placed in Worksheet 1
    The emails in Worksheet 1 do not correspond in any order to Worksheet 2.

    Thus, if email in worksheet one of dick@abc.com matches email in worksheet two of dick@abc.com, I want dicks last name (which is only in worksheet 2), to be filled into that cell.

    Crystal clear right?
     
  13. BrulesRules

    BrulesRules Just grab 'em in the biscuits Gold

    Reputations:
    347,913
    Joined:
    Jan 18, 2012
    Messages:
    133,474
    Likes Received:
    60,158
    Seems like something you would do in Access. But you can't use the Find and replace tool?
     
  14. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
    its not really a find and replace issue. If one cell matches another cell, I want a THIRD cell placed in the blank cell
     
  15. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,068
    Joined:
    Sep 23, 2010
    Messages:
    42,903
    Likes Received:
    15,337
    Maybe somebody else understood it better. Is this it?

    If
    Tab a b1=, gwartney@bigdick.com
    and
    Tab b b1=, gwartney@bigdick.com

    replace contents of Tab b b1 with contents of tab b c1, gwartney@itsnotthatbig.com
     
  16. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
    I need to go lay down - my brain hurts. I will return - hopefully with an answer ITT
     
  17. BrulesRules

    BrulesRules Just grab 'em in the biscuits Gold

    Reputations:
    347,913
    Joined:
    Jan 18, 2012
    Messages:
    133,474
    Likes Received:
    60,158
    that's beyond my level...but I wouldn't use excel for an email database I would use Access.
     
  18. gwartney

    gwartney Unafilliated Gold

    Reputations:
    103,068
    Joined:
    Sep 23, 2010
    Messages:
    42,903
    Likes Received:
    15,337
    I'd be surprised if that can be done in Excel. I'll hang up and listen.
     
  19. Stan Beeman

    Stan Beeman Well-Known Member VIP

    Reputations:
    55,287
    Joined:
    Apr 16, 2012
    Messages:
    23,124
    Likes Received:
    6,834
  20. Lou Loomis

    Lou Loomis Feel the Gern

    Reputations:
    56,402
    Joined:
    Aug 7, 2012
    Messages:
    17,244
    Likes Received:
    9,716
    [video=youtube;sBVq3RQApCM]http://www.youtube.com/watch?v=sBVq3RQApCM[/video]