Prev: Zero Values
Next: spreadsheet part and part without grid lines
From: pol on 26 Apr 2010 17:33
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
From: Gord Dibben on 26 Apr 2010 18:13
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 <pol(a)discussions.microsoft.com>
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

From: pol on 27 Apr 2010 00:57
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



"Gord Dibben" wrote:

> 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 <pol(a)discussions.microsoft.com>
> 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
>
> .
>
From: Gord Dibben on 27 Apr 2010 10:39
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

On Mon, 26 Apr 2010 21:57:01 -0700, pol <pol(a)discussions.microsoft.com>
wrote:

>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
>
>
>
>"Gord Dibben" wrote:
>
>> 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 <pol(a)discussions.microsoft.com>
>> 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
>>
>> .
>>

 | 
Pages: 1
Prev: Zero Values
Next: spreadsheet part and part without grid lines