Results 1 to 8 of 8

find last value in variable length rows and its date column header

Threaded View

  1. 06-18-2021, 05:58 PM #1
    Ruthki
    Ruthki is offline
    Forum Contributor
    Join Date
    06-21-2005
    Location
    Cambridge, England
    Posts
    118

    find last value in variable length rows and its date column header

    Hi
    I need help with a formula to find the last value in a row and then also its column header which is a date
    Rows are of variable lengths. values change over rows, there may be gaps in the data.
    example extract Excel file attached
    Many thanks
    Attached Files Attached Files
    R
    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)

Similar Threads

  1. VBA Insert Blank Line and Header in Variable Length Group
    By Allienne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2018, 08:46 AM
  2. How to find the last number in a variable length column.
    By TonyS52 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2017, 09:39 AM
  3. Find Max value and return column header, multiple rows
    By Setanta11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2015, 04:58 AM
  4. [SOLVED] Find the first empty cell from any of a group of variable length rows
    By j_Southern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-22-2014, 05:47 PM
  5. Find value in column with header and output variable in same row, different column
    By ggibs7 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-01-2013, 06:25 AM
  6. [SOLVED] How to find Column with a header that has a variable that changes evry week
    By JMG14 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-08-2012, 08:20 AM
  7. sort variable length column for min value--number of rows is variable
    By dloe in forum Excel General
    Replies: 6
    Last Post: 04-14-2012, 04:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1