Results 1 to 4 of 4

Grouping Sibling ID into Family ID

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    London
    MS-Off Ver
    Office 2011
    Posts
    2

    Grouping Sibling ID into Family ID

    Hi,

    I have an Excel file where I have the columns:
    - Individual ID
    - Year (either 89 or 94 - this is not particularly relevant for what I want to do in Excel right now but I will need it for some additional purpose later on)
    - Sibling ID
    - Family ID (currently blank)

    I basically want to group individuals into families. If individuals do not have a family, then they will have their own family ID. If individuals have siblings, then they will share the family ID with their sibling. I would like the family IDs to be in ascending order from 1.

    Some information on how the sibling ID column works: In the sibling ID column, the individual fills in the "Individual ID" of their sibling, so for example, if Individual 34's sister is Individual 35, Individual 34 would fill in 35 in the "Sibling ID" column and Individual 35 would fill in 34 in the "Sibling ID" column.

    I don't think this should cause an issue but sometimes, a sibling ID is provided but the individual with that corresponding ID is not in the dataset (for example, Individual ID 24 provides a Sibling ID of 23 but Individual 23 is not in the dataset).

    Also, if there are more than 2 siblings in the dataset (for example, for Individual ID 58, 59 and 60), then the Sibling ID they provide looks like this:
    - Individual 58 provides a Sibling ID of 59
    - Individual 59 provides a Sibling ID of 60
    - Individual 60 provides a Sibling ID of 58

    Please see the Excel file for an example
    Attached Files Attached Files
    Last edited by F4N; 05-05-2016 at 06:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hey! Excel Family!
    By Lamide in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-24-2015, 04:41 PM
  2. Showing next sibling on invoice
    By ympiano in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2014, 09:12 PM
  3. Family budget PLEASE HELP : ) : )
    By 10089kristin in forum Excel General
    Replies: 4
    Last Post: 01-10-2014, 01:23 AM
  4. Family Tree
    By allan1932 in forum Excel General
    Replies: 2
    Last Post: 03-23-2013, 06:33 PM
  5. [SOLVED] Family Budget
    By wycoff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2013, 12:58 PM
  6. Hi 'Big Family' :)
    By chilli in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-08-2012, 12:29 PM
  7. Family tree
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 0
    Last Post: 09-27-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1