Jan 14 2021 10:55 PM
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.
Jan 14 2021 11:21 PM
SolutionJan 14 2021 11:31 PM
Jan 14 2021 11:39 PM
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.
Jan 14 2021 11:21 PM
Solution