Hello all,
This is my first post to the help forum, so I hope I have made what I am looking for as clear as possible and that it might help others with similar questions. It is hard to find help for this specific problem because of the way it is worded. Especially because I am not looking to match items but to find list items that have not yet been taken into consideration.
I have attached the example I am dealing with to this post.
The objective is to return the elements that remain from the index E152-E166, in order, compared to the opposing index G153-G162, the list of items that have already been selected. The resulting list location should be in cells E169 and down until there are no longer any items that have not been considered.
So I am trying to use one formula that I can paste from E169, E170, E171 etc and when there are no more items left to return, it leaves all additional cells blank. IE. the excel command "".
Thanks so much for the assistance,
Andrew