Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing data points causes my line graph not to connect | Charts and Charting in Excel | |||
missing data codes | Excel Discussion (Misc queries) | |||
missing data in excel cells | Excel Discussion (Misc queries) | |||
identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
What variable do you insert for X-cel if there is missing data? | New Users to Excel |