In columns E through L I have a series of names, each one different than the last. In column M I want to insert a name based on a predetermined list but only if that name is not present in the cells E through L and if the cell in column M is blank. If M2 is populated then it should move to M3, and so on. I purposely left column M blank in my example to illustrate that the column will be blank when starting out.
E F G H I J K L M Bob Dan Denise Lenora Michael Lydia Nikk John Nikk Denise Dan Lydia Mercedes Michael Ted Bob Dan Denise Lenora Michael Lydia Nikki Bill Nikk Denise Dan Lydia Mercedes Michael John Bob Dan Denise Lenora Michael Lydia Nikki Ted Nikk Denise Dan Lydia Mercedes Michael Bill Nikk Denise Dan Lydia Mercedes Michael John Nikk Denise Dan Lydia Mercedes Michael Ted
Any thoughts on where I could being?
Bookmarks