One way
In C1: =IF(A1="","",IF(COUNTIF(A:A,A1)1,"Multiple","ok") )
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote:
May I know what formula must I enter at C1 and copy down to locate the
identical references in column A ?

A B C
1 C012 XXX OK
2 B114 XXX MULTIPLE
3 B114 XXX MULTIPLE
4 B114 MULTIPLE
5 F258 OK
6 G652 OK
7 N144 MULTIPLE
8 N144 MULTIPLE
9 T620 OK
10 L862 OK

I need to group together those entries by sorting after that.

Thanks

Low





--
A36B58K641