- Hot Topics
Excel Excel1: Complex Macro.
Under column A from cells 2 to 85000 I have multiple duplicate entries: e.g. INT, INT, INT. In the corresponding cells under column B for all the INT, it means Internal, International, Interval. I need a macro that would identify all duplicate entries in Column A, copy the contents from corresponding cells in column B and paste to one of the cells corresponding to ?INT? in column B separated by ?Or?. e.g. as follows: Sheet1 * 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4 Last edited by aacod; Mar 28th, 2014 at 06:12 PM.
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of March 28, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel