Thread: Filter Multiple Criteria - Show me the MONEY!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
  
Posts: 76
Default 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?
Reply With QuoteReply With Quote