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?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,517
Messages
5,596,619
Members
414,081
Latest member
Subaru_Steve

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