Thread: Advanced Filter Critera using formula not working
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Advanced Filter Critera using formula not working
Try replacing ISNA with ISNUMBER in the expression
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KKPeters" wrote:
In my list I am trying to filter out Shippers (to my company) that are
charging
us for shipments to other companies. I have a list of our locations and
want to use either the city or zipcode to filter out the shipments that are
not to our company

I have not had alot of luck using formulas with the Advance Filter Critera

The below formula gives me when they are shipping to my company by city

=ISNA(MATCH('Wrong Vendor'!$H$2,FedEx!$I$1:$I$312,0))

I need the reverse of this. So I get a list of shipments that are NOT to my
company.

Thanks, Krystal Peters
Reply With QuoteReply With Quote