# decision tree

1. ### Logic puzzle - balancing unique decision trees - need help with macro?

Hello, I need some assistance in balancing a decision tree. Instead of showing what to do with a set of inputs, I want to be able to balance the output to zero if the inputs are out of balance. It's probably best with an example... A1 B1 C1 -2 A1 B2 C2 -2 A2 B2 C2 -1 A2 B3 C2 -1 A2...
2. ### Variable User Input - Either a Fixed Input or Cell Reference

I would like to give a user the option of either inputting a fixed number or making reference to another worksheet, but all within one cell if possible. Therefore, it would be a decision first (do you want to input: 1) a fixed number or 2) utilize a reference to another worksheet that contains...
3. ### Having difficulty with this decision tree game...what's wrong?

Trying to work through decision trees using Excel and VBA... If I execute straight from the code I see a blank macro pop up where I usually will select and click run to perform the macro...but it is empty. Any ideas... Sub BoardValue(best_move As Integer, best_value As Integer, _ p11 As...
4. ### Tree Data Structure from Excel Data

I am trying to write a recursive algorithm in VBA that can read data from a table in an Excel range, for example: <TABLE style="WIDTH: 109pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=144 border=0 x:str><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back