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