| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a criteria expression to not include records that start wit
I have a list with some records that start with *. I would like to exclude
these from the list with a query. I have tried Not Like '~*%' but it does not exclude the records. Does anyone have a suggestion for me. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a criteria expression to not include records that start wit
Hi Steve
use an auxiliar column with this formula =if(lefet(a2,1)="*",mid(a2,2,255),a2) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Steve A" escreveu: I have a list with some records that start with *. I would like to exclude these from the list with a query. I have tried Not Like '~*%' but it does not exclude the records. Does anyone have a suggestion for me. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a criteria expression to not include records that start wit
Thanks for your help but I am trying to accomplish this with query so I don't
have to manipulate the table each time I re run the query. "Steve A" wrote: I have a list with some records that start with *. I would like to exclude these from the list with a query. I have tried Not Like '~*%' but it does not exclude the records. Does anyone have a suggestion for me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| random start and calculation | Excel Worksheet Functions | |||
| count between start date and end date | Excel Discussion (Misc queries) | |||
| MIN within range based on criteria | Excel Discussion (Misc queries) | |||
| SUM IF Criteria | Excel Worksheet Functions | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Linear Mode
