Select A1 and CTRL + c

Select column B and CTRL + f then CTRL + v then "find all"


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 14:33:01 -0700, pol
wrote:

Hi all,

Is it possibel the to give find functionality ( ctrl F) in formula bar.

For example I have to find cell A1 value in b:b in entire column , The A1
value may contain in the column B more than one times. So I have to give
find fucntion for the range of b:b

Please help

Pol