Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find identical record in one sheet
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate, but only if an adjacent cell is identical | Excel Worksheet Functions | |||
find identical names in list | Excel Programming | |||
Need to find two consecutive identical cells (in a column). | Excel Programming | |||
I want cell entry to be identical on another sheet | Excel Worksheet Functions | |||
Inexplicable difference in row hiding speed - identical code, identical machines! | Excel Programming |