Pulling frequency data based on name

[sampahmel]

Hi all,

I'm looking to pull frequency data from another sheet, based on the name input in the dashboard.

To note, the fruits may be irregular (i.e. some on monthly basis, others on quarterly) & the type of fruits could be added in the future.

Thank you for your kind help.

 

[bosco_yip]

Please check as per attachment

Regards

 

[sampahmel]

Please check as per attachment

Regards

Hi bosco_yip, thanks for your solutions. This is exactly what I wanted.

Can I further enquire if it's possible to make the drop down list dynamic i.e. to capture new data points as the papaya date series grows.

In addition, your solutions are magical. I can't get how the drop down list in cell G5 "knows" what is the interval of the fruit chosen (e.g. quarterly or annually)? Say, I picked "Coconut" as a fruit, how does the drop down in G5 knows it's quarterly basis? I don't see any formula there except for a INDIRECT() under data validation, even then the data validation merely points me to the fruit chosen.

Hope you can provide some pointers. Thx.

 

[bosco_yip]

Hi,

1] The Dropdown list created by Validation together with Define Name range.

2] Please check further detail from below link regarding to create Dependent Drop Down Lists

http://www.contextures.com/xlDataVal02.html

Regards