I have a doozy. At least for me. I am using Excel 2003.
I have a two lists of documents. I want to find out if a document exists on both lists. Not a problem. The problem is that there are two file naming conventions in use.
The old standard: Document Number_Document Name_OurDocumentType.fileextention for example: L2_3_2_This is a document_REFERENCE.pdf
The new standard is Document Name (Document Number) OurDocumentType for example: This is a document (L2_3_2) Reference
The document number can vary in size and length so it could be L3_1 or L3_1_54_34
Document types can be reference, processes, procedures, etc.
Is there a way to reconcile these using a fancy formula? Or am I forced to manually reconcile....
Thanks in advance.
I have a two lists of documents. I want to find out if a document exists on both lists. Not a problem. The problem is that there are two file naming conventions in use.
The old standard: Document Number_Document Name_OurDocumentType.fileextention for example: L2_3_2_This is a document_REFERENCE.pdf
The new standard is Document Name (Document Number) OurDocumentType for example: This is a document (L2_3_2) Reference
The document number can vary in size and length so it could be L3_1 or L3_1_54_34
Document types can be reference, processes, procedures, etc.
Is there a way to reconcile these using a fancy formula? Or am I forced to manually reconcile....
Thanks in advance.