Excel formula to Validate Document Numbers

Microsoft corporation Excel 2007
September 13, 2011 at 10:28:58
Specs: Windows 2007, Pentium 4 2GHz / 4 gigs
Column A Column B Column C Column D
Project Area Name Discipline Doc Type
SPM Project 4210 – Ore Prep 02-Civil Civil Typical Details-02C

SPM = 005B Document Number to Validate: 005B-210-02-C111

I am trying to create a formula to validate the above document number. The document number consists of the certain information from the above columns. The information I need to from each column is:

Column A Column B Column C Column D
SPM = 005B 210 02 C


See More: Excel formula to Validate Document Numbers

Report •


#1
September 13, 2011 at 10:51:59
Please click on the following blue line and read the instructions on how to post data in this forum. That way there will be no confusion as to what data is in which column.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 13, 2011 at 11:22:24
Column A           Column B                Column C          Column D

Project               Area Name              Discipline          Doc Type

SPM Project       4210 - Ore Prep       02-Civil             Civil Details-02C

SPM = 005B	Document Number to Validate: 005B-210-02-C111

I am trying to create a formula to validate the above document number. The document number consists of the certain information from the above columns. The information I need to from each column is:
Column A               Column B	  Column C      Column D

SPM = 005B              210                   02                 C


Report •

#3
September 13, 2011 at 13:08:58
re: "validate the above document number"

What do you mean by "validate"?

re: "The information I need to from each column is:"

Need to from? What does that mean?

I don't think you've provided enough information for us to be able to help.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
September 13, 2011 at 13:34:29
By validate I mean confirm the document number is correct based on the meta data from columns A, B, C and D. The document number consists of the Project SPM = 005B the Area Name 4210 - Ore Prep Discipline 02-Civil and Document Type Civil Deails-02C.

     Project       Area  Discipline - Document Type

SPM=005B     4210      02               02C

Document Number  005B-210-02-C


Report •

#5
September 13, 2011 at 19:17:15
Keep in mind that we have no clue what criteria you are using to determine if the document number is "correct" or not.

Based on what you've given us - some text strings in Columns A:D and a "document number" - how are we supposed to know if that document number is "correct" or not? You haven't told us whether is it or isn't correct nor have you given given us the reasons why.

In fact, you've given us two different document numbers in responses 2 and 4. Is one supposed to be correct and the other not or are they both correct or both not correct?

We can't read minds. Tell us whether the document number(s) you've given us are correct or not and tell us *why* they are or are not correct.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
September 14, 2011 at 07:51:58
The document numbers are correct. They are correct because the document consists of the information contained in the columns.

Project       Area  Discipline - Document Type

SPM=005B     4210      02               02C

Document Number  005B-210-02-C



Report •

Ask Question