Duartion to Grid Using Binary Number String

Hello there knowledgeable folk,

I'm a timetabler working with exports of timetable data from various softwares.

I'm looking for what I think is a simple formula, the desired result being shown in the attached file.

The export from the timetabling software contains a binary string of 52 characters (1s and 0s of course), with any 1s representing the activity happening in any one or multiple weeks of the 52-week year.

I need a formula to pop into the grid of 1-52 on the right, that returns the value in the Duration column to the appropriate weeks indicated in the Week Pattern Binary column, if that activity is set to take place during that week, otherwise returning a zero.

The end result being the grid on the right that has one week per column, and the duration of that row inserted into the correct columns.

Any help here would be greatly appreciated!

Thank you kindly,

Excel W

That is fantastic, and works a treat.


Thank you Bebo, your response has saved me much time today!