Results 1 to 3 of 3

Formula to show the latest revisions of a certain document

Threaded View

  1. 06-16-2019, 04:37 AM #1
    Excel_Newie
    Excel_Newie is offline
    Registered User
    Join Date
    05-23-2019
    Location
    Qatar
    MS-Off Ver
    2013
    Posts
    3

    Formula to show the latest revisions of a certain document

    Hi Guys,

    Need a big help for formula to show the latest revision.

    AA001 (A3) - Latest revison from J3 to T3 is Rev 0. So the latest revision details will show in B3 to G3
    AA002 (A4) - Latest revison from J3 to T3 is Rev 1. So the latest revision will show in B3 to G3

    Please refer to attached screenshot.

    Thank you so much.
    Attached Images Attached Images
    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. [SOLVED] Formula to show the latest date in a given year from a column of dates
    By Mgc26133 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2018, 10:00 AM
  2. [SOLVED] Formula to Look for value then for latest date then show value in third column
    By Jamidd1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-12-2017, 11:16 AM
  3. How to show latest thread only?
    By london7871 in forum Suggestions for Improvement
    Replies: 2
    Last Post: 10-06-2017, 03:32 AM
  4. Need help to show only the latest date
    By stuhico09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2015, 04:00 AM
  5. Open the latest file in a folder, and the second latest - up till the tenth latest saved
    By nikolajfh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-28-2013, 05:20 PM
  6. formula at the top of the sheet to show the latest figure in column
    By karloss in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2009, 12:30 PM

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