ExcelBanter - Filter Multiple Criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter Multiple Criteria - Show me the MONEY! (https://www.excelbanter.com/excel-discussion-misc-queries/218903-filter-multiple-criteria-show-me-money.html)

Teddy-B

Filter Multiple Criteria - Show me the MONEY!

IN cells O3 thru P4 I have: Time In Time In
=39845.0833333333
<=39846.0833217593
And I filter my Data with:
Range("I6:IJ5000").AdvancedFilter Action:=xlFilterInPlace,
CriteriaRange:= _
Range("O3:P4"), Unique:=False
I want to add another criteria to the filter to show only cellls that have a
value of $1,000 in Range("K6:K5000")

Can you help me with the formula?

Herbert Seidenberg

Filter Multiple Criteria - Show me the MONEY!

Excel 2007
Similar data; with code:
http://www.mediafire.com/file/h1kmctzjayw/02_02_09.xlsm

All times are GMT +1. The time now is 12:05 AM.