Excel 2002: How to locate identical references ?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to fill group of of odd number in sequence ? 9
Excel 2002 : How to insert a bank row between different codes ? 4
Excel 2002: How to sum up base on date parameters ? 4
Excel 2002: Can Vlookup search for identical references ? 1
Excel 2002: Conditional format multiband colors 3
Excel 2002: How to use Auto Filter ? 2
Excel 2002 : Is there any active row bar to aid data entry ? 3
Excel 2002 : How to move to the next cell with content ? 2

Top