+ Reply to Thread
Results 1 to 5 of 5

Group by family

  1. #1
    Registered User
    Join Date
    08-23-2015
    Location
    Mons, Belgium
    MS-Off Ver
    2010
    Posts
    6

    Group by family

    Hello everyone,
    My database "BD" mainly contains the information for the follow-up of my breeding of canaries:
    Column "A": Reference of newborns (Young canaries).
    Column "B": Reference of breeding males.
    Column "C": Reference of breeding females.
    A family can have 1 young, sometimes 2 or more young.
    I want to gather in the sheet "Fa" all the young people who have the same father and the same mother.
    In other words, we will group all the lines that have the same cells in column "B" + the same cells in column "C".
    For more visibility, a line will be inserted between each family.
    If I am not mistaken, you will find in the attachment in the "Family" sheet the desired result.
    Thank you for your answers.
    ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
    Voici ma demande en Français :
    Bonjour à tous,
    Ma base de données "BD" contient principalement les informations pour le suivi de mon élevage de canaris*:
    En Colonne "A"*: Référence des jeunes nés.
    En Colonne "B"*: Référence des mâles reproducteurs.
    En Colonne "C"*: Référence des femelles reproductrices.
    Une famille peut avoir 1 jeune, parfois 2 jeunes voir plus.
    Je souhaite regrouper dans la feuille "Fa" tous les jeunes qui ont le même père et la même mère.
    Autrement dit, on va regrouper toutes les lignes qui ont les mêmes cellules dans la colonne "B" + les mêmes cellules dans la colonne "C".
    Pour plus de visibilité, une ligne sera insérée entre chaque famille.
    Sauf erreur de ma part, vous trouverez dans la pièce jointe, dans la Feuille "Famille" le résultat souhaité.
    Merci pour vos réponses.
    Attached Files Attached Files

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Group by family

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

  3. #3
    Registered User
    Join Date
    08-23-2015
    Location
    Mons, Belgium
    MS-Off Ver
    2010
    Posts
    6

    Re: Group by family

    Hello karedog,
    Thank you very much for your code, it gives me the desired result and satisfies me perfectly.
    Yours truly.

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Group by family

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    08-23-2015
    Location
    Mons, Belgium
    MS-Off Ver
    2010
    Posts
    6

    Re: Group by family

    Hello,
    I am sorry but I can not find or put that the subject is solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  2. How to generate automatic Family Unique Group ID
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2016, 01:18 PM
  3. [SOLVED] How to generate automatic Family Unique Group ID - Tried with few formula
    By bala04msw in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-30-2016, 06:48 AM
  4. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  5. Hello, i am new joiner in Excel group family here
    By Rein1010 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-30-2013, 01:11 AM
  6. Family Tree
    By allan1932 in forum Excel General
    Replies: 2
    Last Post: 03-23-2013, 06:33 PM
  7. Hi 'Big Family' :)
    By chilli in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-08-2012, 12:29 PM

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