Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fIND GIVES NO RESULTS
wHEN I USE THE FIND FACILITY I GET NO RESULTS EVEN IF THE WORD OR
NUMBERI SEARCH FOR IS THE ONLY ENTRY IN THE SHEET . i HAVE TRIED AND TRIED BUT NOTHING |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fIND GIVES NO RESULTS
Do you have the "match entire cell contents" (under Options) checked?
Do you have "match case" checked? Do you look in formulas or Values? What are you looking for? Could it be masked by some sort of number format? john wrote: wHEN I USE THE FIND FACILITY I GET NO RESULTS EVEN IF THE WORD OR NUMBERI SEARCH FOR IS THE ONLY ENTRY IN THE SHEET . i HAVE TRIED AND TRIED BUT NOTHING -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fIND GIVES NO RESULTS
tHANKS
The number format option was the problem. "Dave Peterson" wrote: Do you have the "match entire cell contents" (under Options) checked? Do you have "match case" checked? Do you look in formulas or Values? What are you looking for? Could it be masked by some sort of number format? john wrote: wHEN I USE THE FIND FACILITY I GET NO RESULTS EVEN IF THE WORD OR NUMBERI SEARCH FOR IS THE ONLY ENTRY IN THE SHEET . i HAVE TRIED AND TRIED BUT NOTHING -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Numeric Criterion in Column & Return the Numeric Value from Row above | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Date stamp formula results? Tricky problem? | Excel Discussion (Misc queries) | |||
export find results | Excel Discussion (Misc queries) | |||
How do I Print the Results of a FIND ALL from multiple worksheets? | Excel Worksheet Functions |