Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the numb
I am having difficulties with the FIND wizard not finding a number that is
conatined in the column I am searching in. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the numb
Make sure that there is no "stray" spaces behind or in front of the number
when you typed it into the FIND wizard. If that doesn't work, you may have the stray space actually in the cell you're looking for, and so the FIND wizard is not recognizing the number. Try using the filter feature found in the DATA menu to create a quick drop down list in that column and clicking on the resulting arrow will list all the values in decending order... you can find your number and make sure there are no stray spaces or symbols by it. (of course, you can also use the good ole sort feature) "fdp" wrote: I am having difficulties with the FIND wizard not finding a number that is conatined in the column I am searching in. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the
Thanks for your suggestion. Went through the filter process but found no
starnge characters.... Thanks for the help "Stilla" wrote: Make sure that there is no "stray" spaces behind or in front of the number when you typed it into the FIND wizard. If that doesn't work, you may have the stray space actually in the cell you're looking for, and so the FIND wizard is not recognizing the number. Try using the filter feature found in the DATA menu to create a quick drop down list in that column and clicking on the resulting arrow will list all the values in decending order... you can find your number and make sure there are no stray spaces or symbols by it. (of course, you can also use the good ole sort feature) "fdp" wrote: I am having difficulties with the FIND wizard not finding a number that is conatined in the column I am searching in. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the numb
Are you searching for entire cell contents or part of cell?
Do you have any extraneous spaces if searching by whole cell? Gord Dibben Excel MVP On Wed, 7 Dec 2005 09:56:03 -0800, fdp wrote: I am having difficulties with the FIND wizard not finding a number that is conatined in the column I am searching in. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the
I do not have the box checked for search entire.... Do you think this is why
I am having problems? There does not appear to be any funny characters or spaces. Regards "Gord Dibben" wrote: Are you searching for entire cell contents or part of cell? Do you have any extraneous spaces if searching by whole cell? Gord Dibben Excel MVP On Wed, 7 Dec 2005 09:56:03 -0800, fdp wrote: I am having difficulties with the FIND wizard not finding a number that is conatined in the column I am searching in. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND is not "finding" a number in a column which contains the
If the numbers are contained with other text/numbers in a cell you would not
select "entire cell contents". e.g 12345 in a cell Look for 234 If you have "entire cell contents" checked Find would not find 234 What does your data consist of? Spaces can be hard to see. In an adjacent column enter =LEN(cellref) and copy down. Is the length returned the same as your data? Show us an example of your data. Gord On Wed, 7 Dec 2005 12:55:02 -0800, fdp wrote: I do not have the box checked for search entire.... Do you think this is why I am having problems? There does not appear to be any funny characters or spaces. Regards "Gord Dibben" wrote: Are you searching for entire cell contents or part of cell? Do you have any extraneous spaces if searching by whole cell? Gord Dibben Excel MVP On Wed, 7 Dec 2005 09:56:03 -0800, fdp wrote: I am having difficulties with the FIND wizard not finding a number that is conatined in the column I am searching in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
look up number in column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
find the largest number in column | Excel Discussion (Misc queries) | |||
How do I find a column entry closest to a particular value | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |