+ Reply to Thread
Results 1 to 2 of 2

Want to pick up cell column id of first non-blank cell in a row

  1. 07-23-2007, 12:59 PM #1
    noceps
    noceps is offline
    Registered User
    Join Date
    01-04-2006
    Posts
    7

    Want to pick up cell column id of first non-blank cell in a row

    Want to pick up cell column id of first non-blank cell in a row.

    For example ....

    A B C D E F
    1 5 5 5
    2 5 5 5
    3 5
    4 5 5
    5 6

    I want to automatically know that for Row 1 the first entry with a number is Column B.

    In Row 2 it will be C, Row 3 it will be F, and so on.

    Regards Ray
    Last edited by noceps; 07-23-2007 at 01:02 PM.
    Reply With QuoteRegister To Reply
  2. 07-23-2007, 02:17 PM #2
    SteveG
    SteveG is offline
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    Ray,

    If you just want the letter that represents the column then you could use,

    Please Login or Register  to view this content.
    Array formula committed with Ctrl+Shift+Enter not just enter. If you want the cell address (A1, B1, C1 etc...)

    Please Login or Register  to view this content.
    Again an array formula. If just want the column number then,

    Please Login or Register  to view this content.
    Also an array formula.

    HTH

    Steve
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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