Results 1 to 5 of 5

Display last text value depending on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    Manhattan, Kansas
    MS-Off Ver
    Excel 2007
    Posts
    17

    Display last text value depending on another cell

    I have attached an example spreadsheet showing what I need help with.

    To try to explain it, I need to look up the last value for each person listed in another column. So, the people's names will repeat down one column and may or may not have text in the adjacent column. I need to display the last text value adjacent to each person's name.

    John Half
    Steve
    Joe
    John
    Joe Half
    Joe
    Steve Done
    Matt
    John Done
    Steve

    Table:
    John:
    Steve:
    Joe:
    Matt:

    Thanks
    Attached Files Attached Files
    Last edited by willia97; 11-08-2012 at 11:49 AM.

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