Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort and filter | Excel Discussion (Misc queries) | |||
Filter & Sort | Excel Worksheet Functions | |||
Sort & Filter | Excel Discussion (Misc queries) | |||
Filter, sort and sum | Excel Discussion (Misc queries) | |||
Filter and sort | Excel Discussion (Misc queries) |