Home

Simultaneous sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-741465%22%20slang%3D%22en-US%22%3ESimultaneous%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741465%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20trouble%20sorting%20information%20between%20pages%2C%20I%20have%20a%20list%20of%20unit%20numbers%20on%20an%20inspection%20page%20used%20for%20data%20collection.%20When%20the%20cells%20have%20been%20filled%20with%20the%20data%20collected%20it%20shows%20costs%20and%20all%20relative%20data%20on%20the%20second%20page.%20I%20was%20able%20to%20get%20it%20to%20work%20relatively%20however%20when%20ever%20I%20sort%20the%20second%20page%20or%20the%20first%20the%20data%20collected%20doesn't%20correlate%20unless%20both%20pages%20are%20sorted%20in%20the%20same%20manner.%20I%20have%20tried%20everything.%20I'm%20severely%20stuck%2C%20any%20help%20would%20be%20amazing.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-741465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741584%22%20slang%3D%22en-US%22%3ERe%3A%20Simultaneous%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372303%22%20target%3D%22_blank%22%3E%40Gchacon%3C%2FA%3E%26nbsp%3B%20It%20would%20be%20helpful%20to%20see%20a%20small%20data%20sample%20in%20an%20Excel%20file.%20Can%20you%20create%20a%20copy%20of%20your%20workbook%20and%20use%20only%20a%20few%20rows%20of%20data%20that%20illustrate%20the%20problem%3F%20Upload%20that%20file%20so%20we%20can%20have%20a%20lookk.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742273%22%20slang%3D%22en-US%22%3ERe%3A%20Simultaneous%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742273%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3EI%20tried%20to%20copy%20paste%20some%20of%20it%20but%20it%20won't%20work%20right%20due%20to%20the%20communication%20to%20the%20other%20adjoining%20pages%20so%20I%20just%20put%20the%20whole%20thing%20in.%20Its%20the%20inspection%20page%20and%20the%20Vacants%20pages%20that%20aren't%20switching%20together.%20When%20sorting%2C%20the%20data%20collected%20for%20a%20specific%20unit%20is%20not%20staying%20with%20the%20unit%20number%20only%20the%20po%20numbers%20are%20transposing%20with%20the%20unit.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742560%22%20slang%3D%22en-US%22%3ERe%3A%20Simultaneous%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742560%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Gchacon%2C%3C%2FP%3E%3CP%3EThere%20is%20small%20inconsistency%20in%20the%20data%2C%20for%20instance%20in%20'Vacant'%20sheet%20two%20values%20are%20fixed%20and%20not%20linked%20with%20'inspection'%20sheet.%20May%20be%20this%20is%20the%20reason%20that%20sorting%20function%20is%20not%20giving%20desired%20results.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20cell%20C6%20%26amp%3B%20C112%20of%26nbsp%3B'Vacant'%20sheet.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Gchacon
New Contributor

I'm having trouble sorting information between pages, I have a list of unit numbers on an inspection page used for data collection. When the cells have been filled with the data collected it shows costs and all relative data on the second page. I was able to get it to work relatively however when ever I sort the second page or the first the data collected doesn't correlate unless both pages are sorted in the same manner. I have tried everything. I'm severely stuck, any help would be amazing.

3 Replies
Highlighted

@Gchacon  It would be helpful to see a small data sample in an Excel file. Can you create a copy of your workbook and use only a few rows of data that illustrate the problem? Upload that file so we can have a lookk.

@Ingeborg HawighorstI tried to copy paste some of it but it won't work right due to the communication to the other adjoining pages so I just put the whole thing in. Its the inspection page and the Vacants pages that aren't switching together. When sorting, the data collected for a specific unit is not staying with the unit number only the po numbers are transposing with the unit. 

Hi Gchacon,

There is small inconsistency in the data, for instance in 'Vacant' sheet two values are fixed and not linked with 'inspection' sheet. May be this is the reason that sorting function is not giving desired results. 

Please check cell C6 & C112 of 'Vacant' sheet.

Thanks

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies