I have a list of items in excel that belong to certain groups. (see
below)

--Sheet 1--
A B
1 Electrical 3.1.1
2 Electrical 3.1.2
3 Electrical 3.1.3
4 Mechanical 3.2.1
5 Mechanical 3.2.2

What I would like to do using array functions is obtain an array of
all the items within the same group on another worksheet. (see below)

--Sheet 2--
A B
1 Electrical 3.1.1
2 Electrical 3.1.2
3 Electrical 3.1.3

I already have a list of all the distinct items within sheet 1 column
A. So this part won't be a problem.

Has anybody ever attempted to try this with array functions instead of
doing it in VB. If anybody could help me with this or point me in the
right direction I would greatly appreciate it.

Thanks for any and all help on this subject.
Jeff