Ctrl F

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ltstrong@hotmail.com - 19 Apr 2007 23:15 GMT

I am using the Ctrl F command to search through a 3,000 row
spreadsheet to locate a string of data. I am getting an error message
indicating "Microsoft Excel cannot locate the data you are search for"
However when I page through the data I find it in different cells.
What am I not doing.

Reply to this Message

Niek Otten - 19 Apr 2007 23:31 GMT

Select just one cell before issuing the Ctrl F command or select all of the cells.
If that is not the problem, post again with a sample of your search string

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am using the Ctrl F command to search through a 3,000 row
| spreadsheet to locate a string of data. I am getting an error message
| indicating "Microsoft Excel cannot locate the data you are search for"
| However when I page through the data I find it in different cells.
| What am I not doing.

Reply to this Message

ltstrong@hotmail.com - 20 Apr 2007 00:00 GMT

> Select just one cell before issuing the Ctrl F command or select all of the cells.
> If that is not the problem, post again with a sample of your search string
[quoted text clipped - 12 lines]
> | However when I page through the data I find it in different cells.
> | What am I not doing.

This command works for about three attempts then I begin getting the
error message.

1281.50 is a sample of the data

Reply to this Message

David Biddulph - 20 Apr 2007 00:26 GMT

Is your 1281.50 a text string, or is it a number?

If the latter, then you may well not find it if you look for 128.50. If the
number is actually 128.5 then you will find it if your search for 128.5,
rather than for 128.50. If you search for 128.50 it will find 128.509 (even
it formatted to display as 128.51), but it will not find 128.5, nor will it
find 128.49999999 even if the latter is formatted with 2 decimals to display
as 128.50

Signature

David Biddulph

> This command works for about three attempts then I begin getting the
> error message.
>
> 1281.50 is a sample of the data

> > On Apr 19, 6:31 pm, "Niek Otten" <nicol...@xs4all.nl> wrote:
>> Select just one cell before issuing the Ctrl F command or select all of
[quoted text clipped - 16 lines]
>> | However when I page through the data I find it in different cells.
>> | What am I not doing.

Reply to this Message