I have a drop-down list that selects from a dynamic range of employees. People come and go; recently an employee quit. I removed the name from the list, but now there is an error where her name was selected at those times. Her name needs to remain in the places where it was selected at the time with no error displaying in the cell—but her name is no longer an option from which to choose henceforth. How would I update the following formula I use for the dynamic range so that, if I take a name away, it won’t display an error in the cell?
=OFFSET(SHEET!$D$1,1,0,COUNTA(SHEET!$D:$D)-1,1)
Any help would be greatly appreciated.
Thank you!
Bookmarks