maybe datafilterautofilterwill help

--
Don Guillett
SalesAid Software

"jiang" wrote in message
...
Hello,

I'd like to identify same record in one sheet, and make small report.

For instance, there are three column for one record. Year/Month/Day.

For record one, year 1999/month 12/ day 10/ New York
For record two, year 1998/month 1/day 13/ Shanghai
For record three, year 1999/month 12/day 10/New York
For record four, year 1999/month 12/day 10/ New York
....

In the end of this sheet, i want to creat a report to say, record one and
record three and four are same, with result 'year 1999/month 12/day 10/New
York'. Pivot table doesn't really work if combination is too many.

Is there any suggestion? in VBA or formula? Thanks in advance.