Hi Graham

Depending on which version of excel you are using you need to create a
custom list containing "Field 1, Field 2....,Field 10". Use the list to sort
by.

Hopes it helps

Best regars,
Per

"Graham H" skrev i meddelelsen
...
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