Hi, i have two columns. A and B. column A contains the data. column
doesnt contain anything yet. i want to make a macro so that column a i
searched, and only one value of each duplicate value found is put int
column b. i have shown the origional table and the table that i wan
after the macro has been run to try and help explain what i am wantin
to do. Many thanks chris.

ORIG IONAL:

| a | b |
---------
| 1 | |
---------
| 2 | |
---------
| 1 | |
---------
| 2 | |
---------
| 2 | |
---------
| 1 | |
---------

NEW - AFTER MACRO RUN:
| a | b |
---------
| 1 | 1 |
---------
| 2 | 2 |
---------
| 1 | |
---------
| 2 | |
---------
| 2 | |
---------
| 1 | |
--------

--
Message posted from http://www.ExcelForum.com