Ctrl F

[ltstrong]

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.

 

[Niek Otten]

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

--
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.
|

 

[ltstrong]

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

--
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.
|

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

1281.50 is a sample of the data

 

[David Biddulph]

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