Hello
Worksheet with 19,501 rows with products numbers. Different people will
have access to this worksheet . what I want to do is have the person enter
the first 2 or 3 digits of the product number then everything that starts
with those numbers will filter thanks

easiest way to do it is to use Autofilter (Data-Autofilter)

Then in the filter criteria, you could select begins with 123 (or any
number combo you want).

On Jan 14, 11:00 am, Wanna Learn
wrote:
Hello
Worksheet with 19,501 rows with products numbers. Different people will
have access to this worksheet . what I want to do is have the person enter
the first 2 or 3 digits of the product number then everything that starts
with those numbers will filter thanks

Thanks I have excel 2002 - I tried data - auto filter - custom - begins
with 13 and I get blank - no answer - however if I select a number from the
drop down list I get the results HELP and thanks

"Tim879" wrote:

easiest way to do it is to use Autofilter (Data-Autofilter)

Then in the filter criteria, you could select begins with 123 (or any
number combo you want).

On Jan 14, 11:00 am, Wanna Learn
wrote:
Hello
Worksheet with 19,501 rows with products numbers. Different people will
have access to this worksheet . what I want to do is have the person enter
the first 2 or 3 digits of the product number then everything that starts
with those numbers will filter thanks

Sorry This worked fine. I just had to clean and trim the column thanks

"Tim879" wrote:

easiest way to do it is to use Autofilter (Data-Autofilter)

Then in the filter criteria, you could select begins with 123 (or any
number combo you want).

On Jan 14, 11:00 am, Wanna Learn
wrote:
Hello
Worksheet with 19,501 rows with products numbers. Different people will
have access to this worksheet . what I want to do is have the person enter
the first 2 or 3 digits of the product number then everything that starts
with those numbers will filter thanks

If your values are really numbers, then your data|Filter|autofilter won't work.

If the numbers are always six digits (say), you could filter by
=123000
<=123999
(to see the values that start with 123)

You could also use a helper column that converts the numbers to text. You can
use a formula like:
=a2&""
(and drag down)

Then filter this helper column by: begins with 123



Wanna Learn wrote:

Hello
Worksheet with 19,501 rows with products numbers. Different people will
have access to this worksheet . what I want to do is have the person enter
the first 2 or 3 digits of the product number then everything that starts
with those numbers will filter thanks

--

Dave Peterson