| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter
My cells include numbers in following format:
cell A1: 1, 14, 18, 34, cell A2: 5, 22, 45, cell A3: 1, 118, 150, .... I want to filter cells to those which contain 18. I use Autofilter, Custom, Contains, 18 But it doesn't filter A3, I guess because it contains 118. How can I filter it to exact number? stremetzky |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Filter
Try adding a comma (or <comma<space) after the 18 in your custom
filter box. Hope this helps. Pete On Nov 24, 2:30 pm, stremetzky wrote: My cells include numbers in following format: cell A1: 1, 14, 18, 34, cell A2: 5, 22, 45, cell A3: 1, 118, 150, ... I want to filter cells to those which contain 18. I use Autofilter, Custom, Contains, 18 But it doesn't filter A3, I guess because it contains 118. How can I filter it to exact number? stremetzky |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Filter
It doesn't change. :(
Thank you anyway. stremetzky |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Filter
In a Custom filter, for the first test enter:
Begins with: 18 Select OR as the operator For the second test enter: Contains: , 18 stremetzky wrote: My cells include numbers in following format: cell A1: 1, 14, 18, 34, cell A2: 5, 22, 45, cell A3: 1, 118, 150, ... I want to filter cells to those which contain 18. I use Autofilter, Custom, Contains, 18 But it doesn't filter A3, I guess because it contains 118. How can I filter it to exact number? stremetzky -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto Filter
On Nov 24, 5:43 pm, Debra Dalgleish wrote:
In a Custom filter, for the first test enter: Begins with: 18 Select OR as the operator For the second test enter: Contains: , 18 stremetzky wrote: My cells include numbers in following format: cell A1: 1, 14, 18, 34, cell A2: 5, 22, 45, cell A3: 1, 118, 150, ... I want to filter cells to those which contain 18. I useAutofilter, Custom, Contains, 18 But it doesn't filter A3, I guess because it contains 118. How can I filter it to exact number? stremetzky -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html I managed to solve it. I've put the data in the cell in the following format: cell A1: ,1,14,18,34, cell A2: ,5,22,45, cell A3: ,1,118,150, than I use Autofilter, Custom, Contains, ",18," Thank you for help! stremetzky |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
| Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
| in data/filter/auto filter | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| Auto-filter won't filter | Excel Worksheet Functions | |||
Hybrid Mode
