+ Reply to Thread
Results 1 to 2 of 2

Returning last name in column based on data in another column

  1. #1
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Returning last name in column based on data in another column

    I have a large list of names in column A (starting A3), this has a number of blanks then a different name, more blanks another name. In B I have a list with numbers and text- each time a number appears in B I would like the blanks in A to be populated with the last name in row A, non number cells should return a blank. Have tried a number of if statements, isnumber, back filling blanks with control G etc but none I can see that will be dynamic enough to return the last name in row A which will keep changing. Sorry I can post a wb right now as will set off all sorts of alarm bells in work, let me know if I haven’t been clear enough – thanks Noel

    A B result
    xxx xxx xxx
    ???? abc
    ???? 123 xxx
    ???? 123 xxx
    ???? efg
    yyy yyy yyy
    ???? 123 yyy
    ???? 123 yyy
    ???? bcd
    zzz cde zzz
    ???? 123 zzz
    Last edited by somesoldiers; 03-05-2012 at 11:10 AM.

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: Returning last name in column based on data in another column

    Figured a way roubnd it in the end by trimming the "blanks" I was after creating and back-filling, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1