Forum Discussion
Automated decision tree
Hello, I am trying to create a workbook that will point to specific cells (outcomes) based on initial selection criteria. For example, I have the option of using Tubing A or Tubing B, and will ne...
Much depends on how the raw database is laid out.
From what you have described, I'd be inclined to start with some of the new Dynamic Array functions, notably FILTER. Here's a YouTube video that Microsoft delivered to explain these. Note, they do require the most current version of Excel, but they're powerful enough that it would be worth your while to upgrade if you've not already done so. https://www.youtube.com/watch?v=9I9DtFOVPIg
A LOT will depend on how you have your data organized to begin with. If you want further help, it would help us help you if you could post a copy of the spreadsheet as you currently have it.