How do I get the Excel Find function to keep finding what I want?
this may not be what you want, but if you are looking for negative values,
you could use the sort function, or if you want the count of negatives then
COUNTIF. not too sure what you are trying to acheive
"Clueless" wrote:
The "Find" function in Excel 2003 finds what I want sometimes, and on the
next worksheet, it will say "Microsoft Office Excel cannot find the data
you're searching for." I would like to look through a column of numbers, and
they all start with 0.____, or a negative -0.____(fill in the blanks with any
given number ie: 0.452213, or -0.59263). My goal is to identify where the
negative numbers occur. I used the Find and Replace function with the
following settings: "Find what: -0."; no format set, "within: Sheet";
"Search: By Columns"; "Look in: Values".
Any way i can get the Find and Replace function to find what i want?
Much appreciated...
|