Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data on which the filter criteria will be Field 1 , Field 2, Field 3, and so on.
The problem is when I set the criteria for Field 1 for example it extracts all the records for Field 1 but also Field 11, 12, 13, 14 etc, basically any Field that starts with 1 and the situation is the same for starting with 2 or 3 etc. I know I can change the field names to something different but this is the normal representation of these records. If there is a workaround it will be used in a programming context for advanced filter copying extracts to worksheets so this may have a bearing on the possible solution. I would value any help. Graham |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter under and above certain criteria | Excel Discussion (Misc queries) | |||
Filter criteria | Excel Discussion (Misc queries) | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
Filter Criteria | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |