# Data Validation - Find and Replace? (Dashboard)

#### smithj96

##### New Member
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

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Hi SmithJ96,

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

Cheers,
Alan.

Hi Alan_P,

Thanks that would make too much sense. Here we go:

ExpireBox

Replies
4
Views
204
Replies
11
Views
469
Replies
0
Views
878
Replies
4
Views
4K
Replies
39
Views
4K

1,203,213
Messages
6,054,196
Members
444,708
Latest member
David R__

### 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.

### Which adblocker are you using?

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

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