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.