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