many-to-one relationship

[Bruce Baird]

I want to automatically create a table in excel based upon
a "many-to-one" relationship.
I have a table of inventoried items:
Asset# Desc Type Function PurDate etc

The "type" cell (field) is what I want to use as the basis
of the many-to-one. In other words, if there are a number
of "types" with the designation of LP, for instance, then I
want to have excel create a table displaying just the LP
records in my inventory table.

Hope this makes sense. Can it be done inside of Excel or
do I have to go "external" using Access or whatever.

Many thanks,
Bruce

 

[Harlan Grove]

I want to automatically create a table in excel based upon
a "many-to-one" relationship.
I have a table of inventoried items:
Asset# Desc Type Function PurDate etc

I'll assume this means you have a table in A1:whatever with field names in row 1
and the Type field is in column C.

The "type" cell (field) is what I want to use as the basis
of the many-to-one. In other words, if there are a number
of "types" with the designation of LP, for instance, then I
want to have excel create a table displaying just the LP
records in my inventory table.

...

If you mean you want to pull all the distinct types from the Type field in the
table, then it can be done fairly painlessly in Excel. If the full extent of the
Type field *excluding* its field name were C2:C1001, and the topmost cell in the
result table were X2, then enter these formulas.

X2:
=C2

X3: [array formula]
=INDEX($C$2:$C$1001,MATCH(0,COUNTIF(X$2:X2,$C$2:$C$1001),0))

Select X3 and fill down until the formulas return error values.