Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |