Home

Sorting individual numbers and ranges

%3CLINGO-SUB%20id%3D%22lingo-sub-554675%22%20slang%3D%22en-US%22%3ESorting%20individual%20numbers%20and%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-554675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20log%20items%20including%20relevant%20page%20numbers.%20Some%20are%20individual%20pages%20so%20just%20has%20one%20number%20recorded%20i.e.%20200%2C%20some%20are%20multiple%20pages%20recorded%20i.e.%20201-205.%20Recording%20the%20page%20numbers%20in%20this%20way%20means%20I%20am%20unable%20to%20then%20sort%20the%20data%20to%20identify%20any%20missing%20pages.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20on%20how%20I%20can%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankst%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAilsa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-554675%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-556166%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20individual%20numbers%20and%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339374%22%20target%3D%22_blank%22%3E%40AilsaM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20there!%3C%2FP%3E%3CP%3EI%20built%20a%20solution%20for%20you.%20I%20hope%20this%20helps.%20You%20can%20enter%20data%20in%20columns%20A%20and%20B%20and%20columns%20C%2C%20D%20and%20E%20will%20give%20you%20the%20answer%20you%20need.%3C%2FP%3E%3CP%3EGood%20luck!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
AilsaM
Occasional Visitor

Hi 

 

I am trying to log items including relevant page numbers. Some are individual pages so just has one number recorded i.e. 200, some are multiple pages recorded i.e. 201-205. Recording the page numbers in this way means I am unable to then sort the data to identify any missing pages. 

 

Any help on how I can do this? 

 

Thankst

 

Ailsa

1 Reply

@AilsaM 

Hi, there!

I built a solution for you. I hope this helps. You can enter data in columns A and B and columns C, D and E will give you the answer you need.

Good luck! 

Related Conversations