Respected All! Have Nice Day

I am uploading an excel sheet where I want to add Serial Number in S.No column with the condition that,


  1. If CNIC is Same then same S.No may be added to same CNIC like 1, 1, 1 and 2, 2
  2. and 2nd Joining different jobs title in one cell against same CNIC


Click image for larger version. 

Name:	ss.jpg 
Views:	14 
Size:	60.1 KB 
ID:	10711

I have thousand of records of same nature, please help me out to resolve the issue once for all

Thanks and looking forward to early response


Asim Jan
Whats'App
+923349209011