+ Reply to Thread
Results 1 to 5 of 5

Latest Status, Latest Reason should shown in 1st & 2nd Columns

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    24

    Latest Status, Latest Reason should shown in 1st & 2nd Columns

    Hi all,

    I have Dates in 1st row, second row title I need Latest Status, Latest Reason for that particular row should shown in 1st & 2nd Columns.

    Please see the attachment

    Thanks in advance.

    Prasad Emany
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Latest Status, Latest Reason should shown in 1st & 2nd Columns

    What would a sample answer look like?

    perhaps this for the date...
    =INDEX($C$1:$CQ$1,,COUNTA(C3:CQ3)-2)
    and this for the reason...
    =INDEX($C$1:$CQ$1,,COUNTA(C3:CQ3))

    On a side note, its almost always better to make your worksheet grow downwards, rather than across, ie, have dates going down, rather than across the top
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-04-2013
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    24

    Re: Latest Status, Latest Reason should shown in 1st & 2nd Columns

    Dear Ford,

    Many Thanks for your solution

    Actually I need Latest Status and Latest Reason. Date not required. you have given solution for date and reason.

    Please suggest me on Latest Status and Latest Reason
    Last edited by prasademany; 05-22-2015 at 11:36 PM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Latest Status, Latest Reason should shown in 1st & 2nd Columns

    use this instead...
    =INDEX(C3:CQ3,,COUNTA(C3:CQ3)-1)
    and
    =INDEX(C3:CQ3,,COUNTA(C3:CQ3))

  5. #5
    Registered User
    Join Date
    10-04-2013
    Location
    India
    MS-Off Ver
    Excel 365
    Posts
    24

    Re: Latest Status, Latest Reason should shown in 1st & 2nd Columns

    Thanks A Lot....All it's worked for me....

+ 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. Lookup latest status from database
    By adam2308 in forum Excel General
    Replies: 2
    Last Post: 12-08-2013, 09:23 PM
  2. Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  3. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  4. Replies: 4
    Last Post: 04-08-2012, 09:43 PM
  5. Open Latest TextFile with latest TimeStamp
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 10:03 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