Hi
I'm trying to make a dropdown list that removes selected entries and doesn't show any 0 entries.
Someone on reddit posted the following:
Selections are done in column C with the dropdown list configured as =$H$6#
When an items is selected it is removed from the dropdown list.
The original code had the COUNTIF as C6:C11 and that worked great but didn't use all of the available dropdown options, I want to be able to select all options.
When I do that I get the #CALC! message, which then appears in the dropdown list.
Does anyone know how to do this correctly, so the cell in C can be empty or a value from the dropdown.
Thanks
I'm trying to make a dropdown list that removes selected entries and doesn't show any 0 entries.
Someone on reddit posted the following:
Selections are done in column C with the dropdown list configured as =$H$6#
When an items is selected it is removed from the dropdown list.
The original code had the COUNTIF as C6:C11 and that worked great but didn't use all of the available dropdown options, I want to be able to select all options.
When I do that I get the #CALC! message, which then appears in the dropdown list.
Does anyone know how to do this correctly, so the cell in C can be empty or a value from the dropdown.
Thanks