This seems to call out for Data|Filter|Autofilter.

You can use the dropdown arrows to choose and then only the rows that match your
criteria will be visible.

liem wrote:

I have a set of data with 10000 row
Div Market salesman Factor Result
1599 1501 John sales R
1599 1501 John Profit G
1599 1501 John GP% Y
1599 1501 Jeff sales R
1599 1501 Jeff Profit Y
1599 1501 Jeff GP% Y
1699 1601 Robert sales Y
1699 1601 Robert Profit G
1699 1601 Robert GP% R
1699 1601 Ron sales Y
1699 1601 Ron Profit G
1699 1601 Ron GP% R
1799 1602 Susan sales Y
1799 1602 Susan Profit G
1799 1602 Susan GP% Y
1799 1602 Sweet sales Y
1799 1602 Sweet Profit G
1799 1602 Sweet GP% Y

How can the user when they pick or use slice scale it will get back Div and
Market

Div Market -------- pick list
1599 1501

Factor John Jeff
sales R R
profit G Y
GP% Y Y

Thank
liem

--
thanks

--

Dave Peterson