HI,

I need a vba code that does this query

It has to look if the value in column B already exists somewhere else in that column. If so, then it has to return Column A values to the first cell, wherever it matches the value.

ColA ColB ColC
1 SE1 2, 5,6
2 SE1
3 SE2 8,10
4 SE3 7,9
5 SE1
6 SE1
7 SE3
8 SE2
9 SE3
10 SE2

Kindly help,
Thank you,
Bharat

Hello Bharat

Here is a small snippet. Hope it helps

http://vbadud.blogspot.in/2007/08/de...excel-vba.html

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)