Filter 3 digits

W

Wanna Learn

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
 
T

Tim879

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).
 
W

Wanna Learn

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
 
D

Dave Peterson

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
Click to expand...
<=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
 
Top