Thank you Rob.

Names can not be repeated and I am looking for VBA solution.
If Names can be repeated Will you please share your idea.


"Rob van Gelder" wrote:

A problem is that the Person's name in column A is not repeated down.
Is there a possibility that you could repeat the name?

If so, the formula becomes quite easy.

Cheers,
Rob


On 11-Dec-2009 04:46, Atif wrote:
Standard 17" Monitor
.