Count Formula Help

[Sallys1975]

I have a spread sheet with multiple lines of data, where each row may contain a value say "AR" multiple times in that same row (up to 4 times), I want to know if one does appear in the row, but I do not want it counted multiple time, it there an easy way this can be done?

 

[sheetspread]

If(countif()):

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	85	64	67	1	89	41	45	23	12
2	7	22	81	7	85	38	14	9	54
3	85	20	81	6	16	86	18	7	91
4	83	Q	60	60	W	44	34	60	41
5	2	69	66	86	45	35	19	61	1
6	14	56	48	86	42	AR	AR	AT	16	AR FOUND
7	87	8	57	39	81	52	37	70	12
8	87	9	37	46	E	15	15	52	29
9	56	29	69	42	43	33	39	15	35
10	71	100	86	98	81	62	71	AR	95	AR FOUND
11	50	46	R	72	80	26	67	64	93
12	54	76	11	90	23	95	1	76	97
13	70	44	23	82	48	88	72	44	80
14	33	74	AR	51	33	R	34	49	12	AR FOUND
15	46	38	T	74	22	Y	81	94	AR	AR FOUND
16	69	5	11	54	37	2	69	52	20
17	20	2	48	33	26	74	75	26	99
18	39	35	41	84	29	4	98	75	95
19	10	40	63	82	80	U	35	58	20
20	59	1	A	44	19	43	45	71	67
21	69	94	46	64	4	44	81	7	58
Sheet1

Cell Formulas
Range	Formula
J1	=IF(COUNTIF($A1:$I1,"AR")>0,"AR FOUND","")

(or if you just want to know if it appears once change the >0 to =1)

 

[Sallys1975]

Thanks, worked a treat