advanced filter won't allow me to filter on bracketed text (-456.2

G

Guest

I'm trying to use the advanced filter feature to filter a spreadsheet that
shows a variance between two numbers. The variance text shows up in red with
brackets and a minus sign. When i've try to use wildcard operators to pick up
the any text with a bracket i.e. (the number) it will not return any records
though I know they are there... I just learned about advance filter in an
excel class but now am frustrated. Am I doing something wrong is there
another way to filter out these records so I can see only the rows/records
that have variances? Thank you for any help provided. Oh yeah, I'm using
Excel 2000

A.G.
 
F

Frank Kabel

Hi
the brackets are just a format. The underlying values are still simple
negative values. So you have to filter for values <0 to get them
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter help 1
how do I filter on text format in Excel? 2
Extracting results of Advanced Filter. 2
Advanced Filter to combine multiple entries into one totaled entry 1
Advanced Filters not working 3
Advanced Filter - Help 1
Using 3 textboxes to filter a subform either together/independentl 4
output filter string to text box on form 3

Top