Filter Multiple Criteria - Show me the MONEY!

  • Thread starter Thread starter Teddy-B
  • Start date Start date
T

Teddy-B

IN cells O3 thru P4 I have: Time In Time In
=39845.0833333333
Click to expand...
<=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?
 
Back
Top