Formula to allocate name and count in col 'F'.

Originally Posted by :) Sixthsense :)

Based on your data size it is better to go for VBA solution.

Please confirm whether VBA solution is ok for you?

Hi,Sixthsense

Ok no problem .