View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Big Mac Big Mac is offline
external usenet poster
 
Posts: 18
Default sorting atuofilter incorrect output

When I sort 2 columns in a table I get the correct output. eg sorting for
Llandudno in column puts all 13 typed entries of Conway Road above each
other in the second row. When I apply autofilter to the whole table and
select Llandudno I get 2 alphanumeric sets with 3 Conwy Roads in the first
set and 10 in the second set. All entries have been typed by the same person
on the same machine. Formatting appears to be identical but something must be
different, as when I copy one of the top ones and paste over the bottom ones
they all group properly. We have recently upgraded the department to Office
2003. Is there some inconsistency I should look for? I have come across a few
other ones due to the upgrade in other departments

Does anyone have any suggestions
--
Please help