I am trying to find a formula, to be dragged down a col N to produce a list, that will do 2 things.
Firstly look in col P5:P for any positive number.
Secondly return the value that is in col C of same row, but only if value hasn't already been returned.
Does this sound possible. (vague...