View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mr. Low Mr. Low is offline
external usenet poster
 
Posts: 505
Default 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