please explain more detailed
also if we don't want todelete only copy the filtered to other location
thank you

"Max" wrote:

"dk" wrote:
How can you remove filter records which are the same in 3 to 4 columns only
the ones that have in all 3 columns same wording

Assume the 3 cols are cols C to E
In F2, copied down: =SUMPRODUCT(--MATCH(C2:E2,C2:E2,0))=3
Then apply n autofilter for TRUE in F1, delete these filtered rows
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---