Baggeepants
New Member
- Joined
- Jan 9, 2018
- Messages
- 8
Below is an extract from a drawing register spreadsheet & in column B, I require a formula that displays the latest revision of the document. Column E onwards display the received/issued revisions of the documents listed in column A at different times during the life of the project. As new revisions are received a new column is inserted before column E & different suppliers use different revision codes. C1 being a later revision than P3.
<tbody>
</tbody>
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
1 | Document Number | Current Revision | Reason for Issue | R | R | R | ACT | APP | APP | ACT | R | R | APP | R | ACT | ||
2 | Title | | | | | | | | | | | ||||||
4 | C891-B2-AB-34391 | Interlocking Control System Cable Block Diagram | E | A | |||||||||||||
5 | C891-B2-AU-30155 | SLUDGE & LAUNDER COLLECTION ACCESS ROAD LIGHTING GENERAL ARRANGEMENT | P2 | ||||||||||||||
6 | C891-B2-AU-30159 | PRIMARY DIGESTER TANK NO.4 HEAT EXCHANGER ACCESS WALKWAY LIGHTING GENERAL ARRANGEMENT | P2 | ||||||||||||||
7 | C891-B2-AU-30161 | WASHWATER PUMP WWS03P_01 BLOCK CABLE DIAGRAM | C2 | ||||||||||||||
8 | C891-B2-AU-30180 | WASHWATER PUMP WWS03P_01 CONNECTION DIAGRAM | C2 | ||||||||||||||
9 | C891-B2-AU-30182 | PST5 RIO BLOCK CABLE DIAGRAM | |||||||||||||||
10 | C891-B2-AU-30195 | INLET & SLUDGE IMCC BLOCK CABLE DIAGRAM SHEET 4 | P2 | C2 | |||||||||||||
11 | C891-B2-AU-30200 | INLET & SLUDGE MCC ICA COMPARTMENT A1 CONNECTION DIAGRAM SHEET 1 OF 5 | C3 | C2 | C1 | ||||||||||||
24 | C891-HOGSS1ZZ-ELE-SPEC-10085-Addendum02 | ICS Cable Schedule | 5 | 1 | |||||||||||||
25 | Appendix 1 | HMI Screen Switchboards | - | ||||||||||||||
26 | 3334787_B03_04_A03 3 x CRE 45-2-1 VSD Booster Pump Data Sheets | VSD Booster Pump Data Sheets | - | ||||||||||||||
27 | 99195220 as built | Hydro MPC Control Panel 2 Pump Pressure Boosting System EF | B | ||||||||||||||
28 | Control MPC | Installation & Operating Instructions | - | ||||||||||||||
29 | Hydro MPC | Service Instructions | - |
<tbody>
</tbody>