Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 6th 04, 07:59 PM
LucianoG
 
Posts: n/a
Default advanced filter won't allow me to filter on bracketed text (-456.2

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.

  #2   Report Post  
Old December 6th 04, 09:38 PM
Frank Kabel
 
Posts: n/a
Default

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

--
Regards
Frank Kabel
Frankfurt, Germany

"LucianoG" schrieb im Newsbeitrag
...
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017