Results 1 to 2 of 2

Formula to display leftmost cell in a row with a value

Threaded View

  1. 01-15-2009, 06:53 PM #1
    nuentes
    nuentes is offline
    Registered User
    Join Date
    01-15-2009
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2000
    Posts
    1

    Formula to display leftmost cell in a row with a value

    Example attached. I have a collection of data; B2:F6, and there are blank spots in each row. I would like for a function to comb through this, and give me a result that is the same as A11:A15... where it ignores all the enpty cells, and only shows me the leftmost values in each row.

    thanks for any help!!!!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1