C
Chuckee
This post has been re-submitted as its a couple of days old. I have received
an answer that "works" but just need to know one further thing
See below
Thanks, N Harkawat, this works but one question.
When the item is moved to the bottom of the list because it does not satisfy
the criteria (i.e the person is not in) it produces an error of #NUM!. Can
this error be shown as a blank cell instead
Chuckee
an answer that "works" but just need to know one further thing
See below
Thanks, N Harkawat, this works but one question.
When the item is moved to the bottom of the list because it does not satisfy
the criteria (i.e the person is not in) it produces an error of #NUM!. Can
this error be shown as a blank cell instead
Chuckee