Results 1 to 4 of 4

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
    4
    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:	23 
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
    Personal details removed by moderator for OP's security
    Last edited by AliGW; 2021-12-28 at 03:29 PM. Reason: Personal contact details removed for security.

  2. #2
    Acolyte RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    27
    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

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,725
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Please note that this forum's rules require you to declare cross posts (this is when you post the same query on other forums).

    I will provide the required link for you today (you will need to add any others that I don't yet know about, please): https://www.mrexcel.com/board/thread...excel.1191295/

    Thank you for your co-operation and for respecting our rules.
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Neophyte Asim's Avatar
    Join Date
    Nov 2021
    Posts
    4
    Articles
    0
    Excel Version
    2010
    How please share the formula

Posting Permissions

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