Missing or Duplicate Data

[DaveBrown]

I have a simple spreadsheet of 30 columns and 10 rows. Each column should have one cell containing letter "A" one cell containg letter "B" etc to "D" somewhere in the column. The remaining cells will have a dash or fwd slash. The letters will be in different rows in each column. I need to be warned at the base of each column if one of the 5 letters is missing or repeated. Thanks.

[swatsp0p]

You can enter the following in row 11 of Column A, copy to the right as far as needed:

=IF(OR(COUNTIF(A1:A10,"A")<>1,COUNTIF(A1:A10,"B")<>1,COUNTIF(A1:A10,"C")<>1,COUNTIF(A1:A10,"D")<>1),"ERROR","OK")

If one of the letters is missing or duplicated, "ERROR" will be returned, else "OK" will appear in each cell of row 11.

HTH

Bruce