Select a data from drop down list and will result a value of 1 to the selected name

New Contributor

excel problem.png

Hi everyone..just needs help with this problem of mine..

I need to have a value of 1 on their name if selected in the drop-down list.

3 Replies
Best Response confirmed by dhurt1982 (New Contributor)

@dhurt1982 Like this?

Screenshot 2021-01-15 at 08.19.28.png

where A3 contains the drop-down. You can suppress the zeros if needed.

yes..that's exactly what I want...
thanks a lot.


The attached does what you say; whether it does what you want is another matter.

The formula to display the 1s is

= SIGN(Name=validation)

The appearance is just number formatting.