+ Reply to Thread
Results 1 to 4 of 4

Duartion to Grid Using Binary Number String

  1. #1
    Registered User
    Join Date
    01-10-2017
    Location
    UK
    MS-Off Ver
    2013
    Posts
    23

    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

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,848

    Re: Duartion to Grid Using Binary Number String

    Maybe in D2:

    =MID($C2,D$1,1)*$A2

    Drag down and accross

  3. #3
    Registered User
    Join Date
    01-10-2017
    Location
    UK
    MS-Off Ver
    2013
    Posts
    23

    Re: Duartion to Grid Using Binary Number String

    That is fantastic, and works a treat.


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

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    Re: Duartion to Grid Using Binary Number String

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert Binary Weeks to Number String
    By ExcelWashington in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2020, 09:31 AM
  2. Convert Binary Weeks to Number String
    By ExcelWashington in forum Excel General
    Replies: 5
    Last Post: 11-20-2020, 09:31 AM
  3. Save a (binary) file as string in code and write to disk when needed.
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2019, 08:54 AM
  4. Macro for logical AND'ing of two words and creating a binary string 10110...
    By naragam in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2011, 11:24 AM
  5. Solver returns non binary answer in binary constrained cells
    By Tushar Mehta in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 09-06-2005, 08:05 PM
  6. [SOLVED] Solver returns non binary answer in binary constrained cells
    By Navy Student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  7. Solver returns non binary answer in binary constrained cells
    By Navy Student in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1