sveinhelge.urdal
Member
I have a report from an external system showing a long list of documents. List shows document numbers, title revision and so on.
Looking like this
This list consist of about approximately 900 documents and various revisions.
How can I make Excel show only the last revision on the document numbers?
In the example above I want it to show:
Looking like this
Document Number | Revision | Issue reason | Status | Title |
10003276804 | 1 | Issued for CR | 2 | GENERAL ARRANGEMENT |
10003276804 | 2 | Re-issued CR | 2 | GENERAL ARRANGEMENT |
10003276804 | 3 | Re-issued CR | 1 | GENERAL ARRANGEMENT |
10003276805 | 1 | Issued for CR | 3 | GENERAL ARRANGEMENT |
10003276805 | 2 | Re-issued CR | 2 | GENERAL ARRANGEMENT |
10003276805 | 3 | Re-issued CR | 2 | GENERAL ARRANGEMENT |
10003276805 | 4 | Issued for CR | 2 | GENERAL ARRANGEMENT |
10003276805 | 5 | Re-issued CR | 4 | GENERAL ARRANGEMENT |
This list consist of about approximately 900 documents and various revisions.
How can I make Excel show only the last revision on the document numbers?
In the example above I want it to show:
Number | Revision | Issue reason | Status | Title |
10003276804 | 3 | Re-issued CR | 1 | GENERAL ARRANGEMENT |
10003276805 | 5 | Re-issued CR | 4 | GENERAL ARRANGEMENT |