Good afternoon all.
I think this is a simple problem. I say this because I had someone help with a similar issue before, with the solution being attached.
My problem is that I work in timetabling, and need to export data often in a horrible format into excel.
One of the exports involves using a "binary" coding of Weeks 1 to 52. For example, an activity taking plce from weeks 1 to 5, Week 10, and weeks 50 to 52 would be noted as 1111100001000000000000000000000000000000000000000111.
The formula I was furnished with last time arranged for a text-to-binary sort of function, giving the above binary format from text week noting such as "1-10, 11-15"
For this problem, I need a formula or macro that will convert the binary into individually-listed weeks. EG. 1111100001000000000000000000000000000000000000000111 would become 1,2,3,4,5,10,50,51,52
I've attached a spreadsheet that should explain a bit more skilfully
Many thanks all,
Excel Washington
Bookmarks