Thread: Filtering
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jfg jfg is offline
external usenet poster
 
Posts: 44
Default Filtering

I have Office 2003. In Excel, I am attempting to do auto-filtering, and I am
running into a problem: items are appearing that should not appear.

I highlighted my worksheet, clicked Data, Filter, and then AutoFilter. Under
the title Service, I clicked the down-pointing arrow and then clicked
Development. Three items for Development were returned, but Family Portraits
was also returned at the top:
.... Family Portraits ....
.... Development ....
.... Development ....
.... Development ....


When I attempted to filtr the top three amounts, the return was the top
three amounts plus 490.50: 490.50, 1,169.60, 817.50, 953.50, and 817.50. And
there are three items higher than 490 (615, 650, 712).

What can I be doing wrong to cause these incorrect returns?

Thank you very much for any help you can give me.