Hello! Relatively new here and still learning how to use Excel efficiently. Forgive my English also.
Say I want my co-worker to select data from a drop down list I've created. He can select as many as data he can in the preceding cells but should not duplicate on the whole column. Is there any way I can achieve that?
Otherwise, I was wondering if Excel can remove the data that has been already selected from the next drop down list. I basically want my co-worker to choose data from my table in a drop down list type but is not allowed to have duplicates on the next row. Thank you!
Bookmarks