ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with formula for "Advanced Fliter" (https://www.excelbanter.com/excel-discussion-misc-queries/170381-help-formula-advanced-fliter.html)

Eli H-M

Help with formula for "Advanced Fliter"
 
I am trying to use the "Advanced Filter" option under "Data". I am not sure
the exact formula I need to use under "Criteria range". I want the data that
is greater than or equal to 0.25 to be displayed. If you know that exact
formula I need to use, your help would be greatly appreciated.

Pete_UK

Help with formula for "Advanced Fliter"
 
Debra Dalgleish has some detailed notes on using Advanced Filter he

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete

On Dec 20, 1:45 pm, Eli H-M <Eli
wrote:
I am trying to use the "Advanced Filter" option under "Data". I am not sure
the exact formula I need to use under "Criteria range". I want the data that
is greater than or equal to 0.25 to be displayed. If you know that exact
formula I need to use, your help would be greatly appreciated.



rdwj

Help with formula for "Advanced Fliter"
 
Criteria should read something like "0.25". You can use a cell to specify
your criteria, for example in A1 you type "0.25", then under criteria you
point at A1.
rdwj

"Eli H-M" wrote:

I am trying to use the "Advanced Filter" option under "Data". I am not sure
the exact formula I need to use under "Criteria range". I want the data that
is greater than or equal to 0.25 to be displayed. If you know that exact
formula I need to use, your help would be greatly appreciated.



All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com