Hi - I have a table: II. SINGLE SITE #000000[/URL] , align: center"]ALL #000000[/URL] , colspan: 4, align: center"]GRADE LEVEL #000000[/URL] , colspan: 4, align: center"]SUBJECT #7f7f7f[/URL] , align: center"]n/a #4472c4[/URL] , align: center"]PK #4472c4[/URL] , align: center"]Elementary #4472c4[/URL] , align: center"]Middle #4472c4[/URL] , align: center"]High #7f7f7f[/URL] , align: center"]Math #7f7f7f[/URL] , align: center"]ELA #7f7f7f[/URL] , align: center"]Science #7f7f7f[/URL] , align: center"]Social Studies Count Min Mean Median Max 25th percentile 50th percentile 75th percentile 90th percentile I'd like to dynamically display the calculations based on a drop-down menu, where a person could choose a school from a list to then view the values. The counts (etc) would be calculated from a raw data set. Is that possible? Thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel - vary content of table based on filter for table?

Thread starter akswartz85
Start date Feb 14, 2019
Tags

based dynamic content filter percentile table

akswartz85

New Member

Feb 14, 2019

Hi - I have a table:

<style type="text/css"></style>

II. SINGLE SITE


		ALL	GRADE LEVEL	SUBJECT
		n/a	PK	Elementary	Middle	High	Math	ELA	Science	Social Studies
	Count
	Min
	Mean
	Median
	Max

	25th percentile
	50th percentile
	75th percentile
	90th percentile

I'd like to dynamically display the calculations based on a drop-down menu, where a person could choose a school from a list to then view the values. The counts (etc) would be calculated from a raw data set. Is that possible?

Thanks!