Column Check? - Statistical functions?
 

I have columns of 2-character text values first character is always a number
(1-9 and second character is always a letter ('A' or 'B') For example '2A'
'4B' '9A'. I do not have all combinations ie every column. I might not
have '3B' in a column.

I need to make sure that if there is a '2A' in a column that there is
another (and only one other). I've looked at all the COUNT functions and
even some of the TRIM functions, but can't seem to figure out a way to check
thee columns. I can't sort the columns because I need them to retain their
original order.

Ideas?I have columns of 2-character text values first character is always a
number (1-9 and second character is always a letter ('A' or 'B'). For
example €˜2A '4B' '9A'.

I need to make sure that if there is a '2A' in a column that there is
another (and only one other). I've looked at all the COUNT functions and
even some of the TRIM functions, but I can't seem to figure out a way to
check these columns. I can't sort the columns because I need them to retain
their original order.

Ideas?


Here is a sample column:
4A
3A
5A
5B
5B
5A
3A
4A
1A
1B
3B
2A
2A
3B
1B
1A
7A
6A
6B
6B
6A
7A
9A
9B
8A
8A
9B
9A

Column Check? - Statistical functions?
 

Use Conditional Formatting. Lets say the data is in cols A & B & C

Click A1 and:

Format Conditional Formatting... Formula is

=COUNTIF($A$1:$C$20,A1)2

and then pick a nice background color. Colored cells are violations.
--
Gary''s Student - gsnu200779


"fedude" wrote:

I have columns of 2-character text values first character is always a number
(1-9 and second character is always a letter ('A' or 'B') For example '2A'
'4B' '9A'. I do not have all combinations ie every column. I might not
have '3B' in a column.

I need to make sure that if there is a '2A' in a column that there is
another (and only one other). I've looked at all the COUNT functions and
even some of the TRIM functions, but can't seem to figure out a way to check
thee columns. I can't sort the columns because I need them to retain their
original order.

Ideas?I have columns of 2-character text values first character is always a
number (1-9 and second character is always a letter ('A' or 'B'). For
example €˜2A '4B' '9A'.

I need to make sure that if there is a '2A' in a column that there is
another (and only one other). I've looked at all the COUNT functions and
even some of the TRIM functions, but I can't seem to figure out a way to
check these columns. I can't sort the columns because I need them to retain
their original order.

Ideas?


Here is a sample column:
4A
3A
5A
5B
5B
5A
3A
4A
1A
1B
3B
2A
2A
3B
1B
1A
7A
6A
6B
6B
6A
7A
9A
9B
8A
8A
9B
9A

Column Check? - Statistical functions?
 

Thank You. Great Idea....