How to do an analysis by using drop down list in Excel?
I got a group of data in sheet 1 (it will continue add new data).
Now, I need to do analysis in sheet 2 by doing drop list selection (need to select 2-3 option).
for example: name, sex, total of data that will appear later.
~This selection will appear on the top of analysis list~
After choose the selection that I want, then all the relevant data will list out automatically.
*the excel workbook version is 2007*
*window that use is window XP*
– This technique is particularly useful if you use Excel to make … Scenarios in Excel 2003 and earlier, or under “What If Analysis” on the … a way to use the Scenario Manager, but use a drop–down list to display the scenarios.
Financial Modeling in Excel For Dummies … To perform a scenario analysis using data validation drop–down boxes, follow these steps: … On the Settings tab, change the Allow drop–down to List, use the mouse to select the range =$C$2:$E$2, …by active followers uk