Data Validation - Find and Replace? (Dashboard)

smithj96

New Member
Joined
Feb 18, 2016
Messages
2
So I'm not 100% sure if Data Validation is the way to go about this or if there's an easier way to accomplish what I'm trying to do at all. Essentially, I'm trying to build somewhat of a custom dashboard where I'm able to select a name from the dropdown, and populate the metrics below associated with that name. Hard part is, this data is all based off of seven yes/no questions so it's not a simple math formula. Yes being the positive, no being the negative. This is what I have set up so far for the beginning stage of this dashboard (the empty space to the right of the percentages is where I'd like to put total averages month over month for the name selected in a line graph, right now it's just calculating ALL totals in my workbook).

Bob57% Total Avg.
Total Avg. per Question

<tbody>
</tbody>
Question 1:33%
Question 2:67%
Question 3:33%
Question 4:67%
Question 5:67%
Question 6:67%
Question 7:67%

<tbody>
</tbody>
Right now, the cells with percentages are populating with this formula: =COUNTIFS(Sheet18!A:A,"Bob",Sheet18!C:C,"Yes")/COUNTIF(Sheet18!A:A,"Bob"). The data is being grabbed from another raw data sheet. The "Total Avg" cell is simply just averaging the column of per question averages.

The cell with "Bob" is obviously where the data validation is with a list of other names. I'm relatively new to data validation so I'm assuming there's a way to make this happen; but again, being new to this feature, I may be a tad over-ambitious. Any help is greatly appreciate. Please don't be afraid to call me names and tell me I'm insane if that happens to be the case here.

**I'm trying to attach a sample workbook to this message but cant seem to find the option. Any hints?
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Alan_P

Well-known Member
Joined
Jul 8, 2014
Messages
596
Hi SmithJ96,

You'd need to use a website like DropBox or similar to share a copy of your workbook...

Cheers,
Alan.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,273
Messages
5,836,329
Members
430,421
Latest member
Natas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top