Dear Friend,
Kindly follow attachment...
it will work according to your range, if you increase your range still it will work or if you decrease your range still it will work.
if not working kindly send your file and your required output on other sheet for my better understanding.
|