| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro for duplicate values
I would like to run a macro that looks in Column A, finds the first value,
brings back the adjacent value in column B. Then either skips over or deletes the duplicate 1120's and stops at 1140 and bring it's adjacent cells value, skips the next 1140.etc. See below. Any ideas? Example: column A column B 1120 7 May 07 1120 9 May 07 1120 9 May 07 1140 6 June 06 1140 15 July 07 1160 1 Jan 05 1160 15 march 06 Thanks, Italiavb |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro that finds values then sorts | Excel Worksheet Functions | |||
| macro to change multiple values in a column | Excel Discussion (Misc queries) | |||
| formatting date-time values in macro | Excel Worksheet Functions | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Linear Mode
