Sort/Filter

  • Thread starter Thread starter TimBCC
  • Start date Start date
T

TimBCC

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.
 
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...
 
Worked great. Just what I needed. Thanks.

Shane Devenshire said:
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
Click to expand...
 
Back
Top