Happy Thanksgiving, Everyone!
I'm trying to create a table that is dependent on two (percentage) variables. To start, I have my original sheet where I currently manually input the variables. The variables are then used in a calculation sheet and are checked to see how many times the historical data matches the inputs, and returns the number of instances that this happens to a cell in the original sheet.
As there are a lot of different possibilities with two ranges of inputs, I am trying to find a way to return the minimum and maximum instances without having to check each iteration manually. I do not think solver can help, as my end value is not a formula, but rather a count.
I was thinking that a table sheet might be able to solve my dilemma, by creating a different sheet, and using the percentage ranges of x in Row 1, and the percentage changes of y down column A in that same sheet. Is there a way to create a formula in the table, or VBA in the table sheet, that will take the values from column A and and the values from row 1, and insert them, one at a time, as values into the computational sheet, and return the value from the computational sheet?
Does this make sense? I have minimal experience with VBA, but it seems like this should be possible. I am very grateful to have found this site! Thank you all for any help you can give me, or just pointing me in the right direction.
I'm trying to create a table that is dependent on two (percentage) variables. To start, I have my original sheet where I currently manually input the variables. The variables are then used in a calculation sheet and are checked to see how many times the historical data matches the inputs, and returns the number of instances that this happens to a cell in the original sheet.
As there are a lot of different possibilities with two ranges of inputs, I am trying to find a way to return the minimum and maximum instances without having to check each iteration manually. I do not think solver can help, as my end value is not a formula, but rather a count.
I was thinking that a table sheet might be able to solve my dilemma, by creating a different sheet, and using the percentage ranges of x in Row 1, and the percentage changes of y down column A in that same sheet. Is there a way to create a formula in the table, or VBA in the table sheet, that will take the values from column A and and the values from row 1, and insert them, one at a time, as values into the computational sheet, and return the value from the computational sheet?
Does this make sense? I have minimal experience with VBA, but it seems like this should be possible. I am very grateful to have found this site! Thank you all for any help you can give me, or just pointing me in the right direction.