Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Joining identical items to show as one????
Hello to all....I have a task to join several identical items as one. I have tried the Pivot Table but it just gives me qtys. There is hundres (thousands) of entries and to be deleting the extra ones takes a long time. Is there a formula to just show one row of each? See Below. Thanks. example: 4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral 4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral 4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral 4/1/2006 200298247 H0799653801 1 Scrap 2405 Multilateral 4/1/2006 200298230 H0789643202 2 Rework 98415 Liners 4/1/2006 200298230 H0789643202 2 Rework 98415 Liners 4/1/2006 200298230 H0789643202 2 Rework 98415 Liners 4/1/2006 200298230 H0789643202 2 Rework 98415 Liners 4/1/2006 200298230 H0789643202 2 Rework 98415 Liners -- cazajosa ------------------------------------------------------------------------ cazajosa's Profile: http://www.excelforum.com/member.php...o&userid=33649 View this thread: http://www.excelforum.com/showthread...hreadid=534246 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting identical items in a column and returning the occurrences | Excel Discussion (Misc queries) | |||
Show the top three items in a list | Excel Worksheet Functions | |||
checking a sheet for identical items | Excel Programming | |||
Inexplicable difference in row hiding speed - identical code, identical machines! | Excel Programming | |||
Consolidation: Combining groups of identical items | Excel Programming |