Thanx Frank! It is indeed useful.....But one thing can i also filter
more than one row say Unique records in First second and third rows

eg
Row one contains -----1,jag,23
Row two contains -----2,man,34
Row three ----------------1,jag,23
Row four ------------------2,man,22
Row five -------------------2,jag,45

now i want the output should be four rows .......
in adv filter it will delete all duplicate rows with jag OR 1 OR 23 AS
THE CASE MAY BE
THANKS DEAR FRANK FOR THE PROMOT ANSWER AND HAPPY NEW YEAR