Hi.
I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words?
Example.
TEST1
TEST2
TEST3
etc down to TEST10.
I go into another cell and type in TEST1. It would then not show as available so when I click on the next row down, it only gives me the 9 remaining words to choose from. Can a 'Data Validation list' have a list in it that changes as words are added or deleted as you go along?
I need some assistance. Let's say that I have 10 available words in an excel table. In another table, I would type in one of the 10 words. How do I do the formula so the original table shows only the remaining 9 words?
Example.
TEST1
TEST2
TEST3
etc down to TEST10.
I go into another cell and type in TEST1. It would then not show as available so when I click on the next row down, it only gives me the 9 remaining words to choose from. Can a 'Data Validation list' have a list in it that changes as words are added or deleted as you go along?