Thread: How to Filter cells and save the file with certain criteria?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default How to Filter cells and save the file with certain criteria?
And if we wanted to return only the lines with "MO" from X
we would just need to tweak this criteria formula in Y

Put in C1: =IF(X!B1="","",IF(X!B1="MO","",ROW()))

to

Put in C1: =IF(X!B1="","",IF(X!B1<"MO","",ROW()))
and then copy C1 down

(No change to formulas in cols A & B in sheet: Y)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply With QuoteReply With Quote