| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question envolving VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Maybe this is a simple question | Excel Worksheet Functions | |||
| Simple Question | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| simple question, hopefully a simple answer! | Excel Programming | |||
![chrisdarl[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
