SOLVED

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

Copper 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 (Copper Contributor)
Solution

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

@dhurt1982 

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.

 

1 best response

Accepted Solutions
best response confirmed by dhurt1982 (Copper Contributor)
Solution

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

View solution in original post