Excel 2002: How to locate identical references ?
 

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

Excel 2002: How to locate identical references ?
 

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

Excel 2002: How to locate identical references ?
 

Hello Max,

Thanks for your formula.

It works well.

Kind Regards

Low

--
A36B58K641


"Max" wrote:

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

Excel 2002: How to locate identical references ?
 

welcome, Low. Thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mr. Low" wrote in message
...
Hello Max,

Thanks for your formula.

It works well.

Kind Regards

Low