Zeilen zusammenfassen

%3CLINGO-SUB%20id%3D%22lingo-sub-1002004%22%20slang%3D%22de-DE%22%3ESummarize%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002004%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecan%20I%20summarize%20rows%20in%20Excel%20so%20that%20they%20stop%20each%20other%20when%20sorting%3F%20In%20the%20sample%20table%2C%20I%20would%20like%20to%20summarize%20the%20same%20customer%20numbers.%20If%20I%20then%20move%20into%20credit%20after%20e.g.%20descending%2C%20I%20would%20like%20to%20sort%20the%20lines%20of%20the%20company%20with%20Kdnr.%201%20both%20stay%20together.%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1002004%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1002122%22%20slang%3D%22en-US%22%3ERe%3A%20Zeilen%20zusammenfassen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F433297%22%20target%3D%22_blank%22%3E%40DBraun%3C%2FA%3EYou%20can%20sort%20with%20a%20primary%20and%20then%20a%20secondary%20sort%20all%20at%20the%20same%20time.%20See%20the%20attached.%20I%20believe%20it%20does%20what%20you%20want.%20If%20you%20go%20to%20Data.....Sort%2C%20you%20will%20see%20the%20two%20levels%20of%20sorting%20that%20were%20requested.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hallo,

 

kann ich in Excel Zeilen zusammenfassen, so dass diese bei einer Sortierung untereinander stehen bleiben? In der Beispieltabelle würde ich gern die gleichen Kundennummern zusammenfassen. Wenn ich dann in Kredit nach z.B. absteigend sortiere, möchte ich das die Zeilen der Firma mit Kdnr. 1 beide zusammen bleiben.

Ist dies möglich?

1 Reply

@DBraunYou can sort with a primary and then a secondary sort all at the same time. See the attached. I believe it does what you want. If you go to Data.....Sort, you will see the two levels of sorting that were requested.