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.
Attach the workbook, not a picture of it, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
A sample wokbook is preferred, but in this instance there is just about enough in the picture to work with.
I've assumed that all Rev #'s will have an equal number of columns, (based on the heading, column T appears to be the start of Rev #2?) and that there will be no data to the right of the last valid Rev #.
In B3 and fill downFormula:
Please Login or Register to view this content.
In C3, fill right and downFormula:Please Login or Register to view this content.
The 9 in the formulas refer to the number of columns to the left of Rev #0.
The 5 refers to the number of columns for each Rev #.
Columns C and F will probably need to be re-formatted as date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks