Parent Child IDs: How to do that in excel?

[jbesclapez]

Hello,

I would like to know how to use parent child relationship in excel.
In the example below I have Animals : Some are dogs and some are birds... The 2 first columns are improtant to understand as they design the parent-child relationship.

Here is the result of this work in an excel format :

ID	Parent	Sex	Color	Height	Opinion	Danger
Animal		M
Dog	Animal	F		Tall		Dangerous
Poodle	Dog	M	Brown
Sheperd	Dog	F
Australian Sheperd	Sheperd	F			Like
Belgium Sheperd	Sheperd	F			Dislike
German Sheperd	Sheperd	F			Dislike
Rottweiler	Dog	F
Labrador	Dog	F			Like
Yellow Retriever	Labrador	F
Black Retriever	Labrador	F
Chocolate Retriever	Labrador	F
Bird	Animal	F		Small		NotDangerous
Parrot	Bird	M
Amazon Parrots	Parrot	M	Blue		Dislike
Finches	Parrot	M			Like
Lovebirds	Parrot	M	Red

<tbody>
</tbody>

As you can see I added some attributes to it. I am going to use this later in SQL with something like Select All Dogs where Opinion is Like.
But for now, I want to test/try this in excel.

I want to filter the question depending on the ID and an attribute.

I have a table like that :

Question	ID	Attribute
Question1	Animal
Question2	Poodle
Question3	Sheperd	Dislike
Question4	Amazon Parrots
Question5	Finches
Question6	Lovebirds
Question7	Bird
Question8	Animal
Question9	Tall
Question10	Dog	Dangerous

<tbody>
</tbody>

So Question 1 will be asked to all animals
Question 2, only to poodles,
Question 3 to all Sheperd (and childs) that I dislike.


Anyone please know how i can do that in excel?

Thanks

 

[ranman256]

pop it into Microsoft Visio,and it will build the org chart automatically.

 

[jbesclapez]

pop it into Microsoft Visio,and it will build the org chart automatically.

Hi ranman, I do not need the org chart as you call it.

 

[jbesclapez]

Hi ranman, I do not need the org chart as you call it.

it ended up to be a lot more simple than I though... I made an advanced filter.
in the advanced filter I used formulae with vlookup to look for the parent... Then in the line below of the advance filter I was copiying (simple = ) the parent.... untill i go to the root.