How to give find function ( same as of ctrl F) in formula bar

P

pol

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
 
G

Gord Dibben

Select A1 and CTRL + c

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


Gord Dibben MS Excel MVP
 
P

pol

I want to find each cell in a column have to check automatically using
ctrl+f then ctrl+v upto the end of the column. Please anybody have idea.

With many thanks
Pol
 
G

Gord Dibben

What results did you get when you tried the method I posted?

What results did you expect?

What do you want to do with what you find?


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help to search a custom format 5
to create a formula by removing RC[number] 2
Find Command 5
To execute a formula upto in a cell 3
formula help 2
macro on different reports CTRL+F in formula 2
to replace a value in each cell of a column 6
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Top