Thank You
what happens if we want to add another 2 columns to filter
Also sometimes filter by 3 columns sometime by 5

"Max" wrote:

Now that you've clarified your scenario better, try this on a spare copy
1. First, switch the calc mode* to manual (you've got 28k rows)
2. Put this in say, D2:
=IF(COUNTA(A2:C2)<3,"",SUMPRODUCT((A$2:A2=A2)*(B$2 :B2=B2)*(C$2:C2=C2))1)
Copy D2 down to the last row of source data in cols A to C. Press F9 to
calc. Select col D, kill the formulas with an in-place: copy n paste special
as values. Switch the calc mode back to automatic.
3. Apply n autofilter D1 for: TRUE
4. Copy the filtered rows paste special as values/formats into another sheet
5. Post a closure feedback here. Also, click the "Yes" button from where
you're reading this response.

*Click Tools Options Calculation tab (options to switch calc mode are
there)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dk" wrote in message
...
ex: column a: is filename b:date modified c:type
only when all 3 matches the exact same
please note this is only example this is a listing of 28,000 rows of data

.. also if we don't want to delete only copy the filtered to other location