| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
