Results 1 to 4 of 4

return column header of first column that doesn't contain 0

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2008
    MS-Off Ver
    Excel 2003
    Posts
    30

    return column header of first column that doesn't contain 0

    Hi,

    I'm looking for a formula that will return the column header (a date) of the first instance of a number greater than 0.

    For example if columns A through S had dates as in row 1 (header row), and in row 2, every column contained a 0 up until column P, I would want the date (Row 1, Column P) returned? I think this might be a sort of index/match formula, but I am not very familiar with these.

    Appreciate your help.

    Jason
    Last edited by jasonanthony; 02-09-2009 at 05:37 PM.

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