+ Reply to Thread
Results 1 to 3 of 3

Find last non blank cell and return the header

  1. #1
    Registered User
    Join Date
    03-28-2015
    Location
    Calgary, Alberta
    MS-Off Ver
    2007
    Posts
    2

    Find last non blank cell and return the header

    In my attachment, I want to find the last non blank cell after finding the first cell.

    For example, Calvin worked on 12/31/2014 for 1.5 hrs. 12/31/2014 is the first value found after blanks. His last day worked before he took a break was 01/03/2015. I want it to give me the header of the last day before a blank cell.

    I hope this makes sense, I'm new to this site so if you need clarification please ask!

    Thanks!
    Newbie403



    Capture.JPG

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,368

    Re: Find last non blank cell and return the header

    Can you post sample workbook? to avoid us to retype again your table, to attach your sheet, click on "Go Advanced" button and then find paperclip image button to attach your file

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Find last non blank cell and return the header

    Will there always be a blank cell following a non-blank cell?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] To find first non blank cell in a row then return column header
    By divi123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-11-2022, 04:49 AM
  2. [SOLVED] find header value in column, return cell next to it for copy/paste
    By julzhart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2014, 10:29 AM
  3. To find first non blank cell in a row then return column header
    By divi123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 07:14 AM
  4. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  5. [SOLVED] Find last non blank cell in a row then return column header
    By Chad B in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2013, 10:33 AM

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