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.
|