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

"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
---