Checking entire cloumn for values
 

I want to write one macro for checking the values in the column. i.e I
there is any value in the B1 cell, then it should take copy that valu
somewhere else and move to B2. If again that value is there then i
should take it and move next...like hat I want to check all tha valye
of column

--
reen
-----------------------------------------------------------------------
reena's Profile: http://www.excelforum.com/member.php...fo&userid=3044
View this thread: http://www.excelforum.com/showthread.php?threadid=50243

Checking entire cloumn for values
 

How about

=IF(ISNUMBER(MATCH("value",B:B,0)),"value","")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"reena" wrote in
message ...

I want to write one macro for checking the values in the column. i.e If
there is any value in the B1 cell, then it should take copy that value
somewhere else and move to B2. If again that value is there then it
should take it and move next...like hat I want to check all tha valyes
of column B


--
reena
------------------------------------------------------------------------
reena's Profile:
http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=502439