Results 1 to 2 of 2

Thread: Adding formula(s) to add Same Serial Number to same CNIC and joining all Job/Posts

  1. #1
    Neophyte Asim's Avatar
    Join Date
    Nov 2021
    Posts
    1
    Articles
    0
    Excel Version
    2010

    Adding formula(s) to add Same Serial Number to same CNIC and joining all Job/Posts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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:	16 
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

  2. #2
    Acolyte RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    25
    Articles
    0
    Excel Version
    2019
    Condition 1 can be done with formulas. Just look for value of CNIC in all the range above each row. If found, you should search SN for that CNIC, if not, use the max SNr +1.

    But for condition 2 you will need some VBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •