We have a key colum i.e. initialised by 'Y' if there is any duplicate found in any column which is defined as key column then it should highlight in yellow colour ..... now I need to check that key column with concatenation fun......for eg colA and colB and these are key column now colA having 2 & 2 and colB having 2 &3 then it should give the result in concatenate way i.e.- 2&2 and 2&3 should be highlighted how we can do this?? (VBA code required )
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Concatenate the column based on Primary Key
- Thread starter Tanu
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,724
- Office Version
- 365
- Platform
- Windows
Duplicate to: Concatenate the key column
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
Similar threads
- Question
