How about a PivotTable?

Use col A and col B as row values, and in that order.


On Oct 30, 6:40 pm, Jeffrey wrote:
In col A- there are numbers 1 thru 6 -4 times (4 number 1s, four nimber 2s
etc) that as a name associated to the number in col B. How do
i shoe on a separte worksheet all name in col b that is associated with the
number in col a. For ie. list of names that has the number 1 associatedd to
it in col A.