Results 1 to 13 of 13

Using the Power of two to find which options are selected in a recursive fashion

Threaded View

J_Andreas_Lindqvist Using the Power of two to... 11-01-2021, 09:09 AM
Bernie Deitrick Re: Using the Power of two to... 11-01-2021, 10:44 AM
J_Andreas_Lindqvist Re: Using the Power of two to... 11-02-2021, 05:30 AM
JohnTopley Re: Using the Power of two to... 11-02-2021, 09:07 AM
Bernie Deitrick Re: Using the Power of two to... 11-02-2021, 01:52 PM
JohnTopley Re: Using the Power of two to... 11-02-2021, 02:28 PM
J_Andreas_Lindqvist Re: Using the Power of two to... 11-03-2021, 03:24 AM
Bernie Deitrick Re: Using the Power of two to... 11-02-2021, 02:46 PM
J_Andreas_Lindqvist Re: Using the Power of two to... 11-03-2021, 03:23 AM
curiouscat408 Re: Using the Power of two to... 11-02-2021, 05:07 PM
J_Andreas_Lindqvist Re: Using the Power of two to... 11-03-2021, 03:14 AM
AliGW Re: Using the Power of two to... 11-03-2021, 05:04 AM
J_Andreas_Lindqvist Re: Using the Power of two to... 11-03-2021, 05:17 AM
  1. #1
    Registered User
    Join Date
    11-01-2021
    Location
    Oslo
    MS-Off Ver
    Office365
    Posts
    6

    Using the Power of two to find which options are selected in a recursive fashion

    I have a list of options which each has a unique value in the form of Power of Two, 0-24 all corresponding to an option:
    Power of two options.png
    I also have a list with a number, ("Moduler"), corresponding to one or more of these options.
    List of options.png
    I would like to for each such number break out which options has been set.
    I am thinking on the lines of a recursive calclulation in each column, but I am not sure as how to do it properly. Lowest and highest value is fine, but it is the options in between which are difficult.

    Any Ideas here?

    See attached file "Lisenser_perland_20210128.xlsx" for none sensetive information.
    Attached Files Attached Files
    Last edited by J_Andreas_Lindqvist; 11-01-2021 at 09:13 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formulas required for different options selected
    By sameer79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-27-2020, 04:50 AM
  2. Power Query - Load to dialog box seems to be missing options
    By carlito2002wgn in forum Excel General
    Replies: 1
    Last Post: 09-30-2020, 03:22 AM
  3. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  4. [SOLVED] Can't find corrext Index Match formula where different options have same sub-options
    By Ochimus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-27-2016, 06:59 AM
  5. [SOLVED] Recursive find of managers
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2013, 11:32 AM
  6. Find & replace recursive
    By mmer2 in forum Excel General
    Replies: 7
    Last Post: 07-18-2012, 08:41 AM
  7. Find most recent file in recursive filtered folder
    By camaytoc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-06-2011, 05:58 PM

Tags for this Thread

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