Sorting individual numbers and ranges

Copper Contributor

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!