+ Reply to Thread
Results 1 to 4 of 4

Find column number of the furthest non-blank column

  1. #1
    Registered User
    Join Date
    06-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Find column number of the furthest non-blank column

    Hello,

    I am trying to write a formula to give me the column number of the furthest non-blank field in each row. My cells have dates as data and some of them are the same date.

    I want to get the column number so I can write a formula to tell me the column title on column to the right of the furthest non-blank column. For example in my attachment for row 2 it would display "SENT PO TO ROY", which I need help with as well. Any help would be greatly appreciated!

    I have tried

    =MAX((3:3<>"")*COLUMN(3:3))

    and

    LOOKUP(9.99999999999999E+307,B1:E1)

    which works but I need the actual column number, not the cell data

    Does anyone know how to do this?

    File I am trying to do this with is attached.
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Find column number of the furthest non-blank column

    maybe
    =IFERROR(INDEX($B$1:$L$1,MATCH(9.99999999999999E+307,B2:L2)),"")
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Find column number of the furthest non-blank column

    Or

    May be this...

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Registered User
    Join Date
    06-23-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Find column number of the furthest non-blank column

    Thank you very much that worked!

+ 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