Missing or Duplicate Data
 

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.


--
DaveBrown
------------------------------------------------------------------------
DaveBrown's Profile: http://www.excelforum.com/member.php...o&userid=27029
View this thread: http://www.excelforum.com/showthread...hreadid=439167

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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=439167