Sort/Filter
 

I have an existing spreadsheet with equipment numbers in column A. I'm
trying to sort or filter column A by 'begins with' so I have a list that goes
by everything that starts with ones, then starts with twos, etc. to match an
existing list done in another program. Does anyone know of a way to do this?
Thanks.

Sort/Filter
 

Hi,

You can't do that directly because begins with applies to text entries. So
create a second column with formulas like

=LEFT(A1)

And apply the auto filter to this column. Here you will just pick 1 or 2
or...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TimBCC" wrote:

I have an existing spreadsheet with equipment numbers in column A. I'm
trying to sort or filter column A by 'begins with' so I have a list that goes
by everything that starts with ones, then starts with twos, etc. to match an
existing list done in another program. Does anyone know of a way to do this?
Thanks.

Sort/Filter
 

Worked great. Just what I needed. Thanks.

"Shane Devenshire" wrote:

Hi,

You can't do that directly because begins with applies to text entries. So
create a second column with formulas like

=LEFT(A1)

And apply the auto filter to this column. Here you will just pick 1 or 2
or...

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"TimBCC" wrote:

I have an existing spreadsheet with equipment numbers in column A. I'm
trying to sort or filter column A by 'begins with' so I have a list that goes
by everything that starts with ones, then starts with twos, etc. to match an
existing list done in another program. Does anyone know of a way to do this?
Thanks.