Sorting and filtering

I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with filtering
and sorting. Neither function is working with all the selected cells. On more
than one occassion, I have had to sent a spreadsheet to a co-worker and the
functions operate correctly. These are simple basic functions for excel and
there should be no excuse for these not to operate as designed. But what
really is indicative of the monopoly abuse exercised by Microsoft, is that we
users should have to pay in order to get support for such basic functions.
This is like buying a new car and having to pay for the 4th tire.

So now you blew some steam off, what is not working?

--

Regards,

Peo Sjoblom


"dsbiloxi" <[email protected]> wrote in message
news:[email protected]...
> I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with
filtering
> and sorting. Neither function is working with all the selected cells. On
more
> than one occassion, I have had to sent a spreadsheet to a co-worker and
the
> functions operate correctly. These are simple basic functions for excel
and
> there should be no excuse for these not to operate as designed. But what
> really is indicative of the monopoly abuse exercised by Microsoft, is that
we
> users should have to pay in order to get support for such basic functions.
> This is like buying a new car and having to pay for the 4th tire.

My outlook generally is that until I've proved otherwise, it's probably my
mistake, not Excel's. I'm not often wrong wrt that.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"dsbiloxi" <[email protected]> wrote in message
news:[email protected]...
> I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with
filtering
> and sorting. Neither function is working with all the selected cells. On
more
> than one occassion, I have had to sent a spreadsheet to a co-worker and
the
> functions operate correctly. These are simple basic functions for excel
and
> there should be no excuse for these not to operate as designed. But what
> really is indicative of the monopoly abuse exercised by Microsoft, is that
we
> users should have to pay in order to get support for such basic functions.
> This is like buying a new car and having to pay for the 4th tire.

when I attempt to sort all the data, either in ascending or descending order,
I will not get always get all the like data grouped together. For example, I
want to see all of my estimated man-hours for serveral construction projects
by plant systems and there are 10 different systems. When I sort soley by
column entitled "Plant Systems." I expect to find system "400" all grouped
together and likewise if I use the "Autofilter" feature and select "400". But
this is not happening. I may find "400" all over. I have experiemented with
several machine in our office and the only ones that have Excel 2002 and
operating on XP will give me the correct results. I have downloaded all the
upgrades for my Office 2000 and I am still not getting correct results. By
the way, if I did not clarify this point, please note that none of our
machines with Office 2000 produced the correct results. Any help is
appreciated.

"Peo Sjoblom" wrote:

> So now you blew some steam off, what is not working?
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "dsbiloxi" <[email protected]> wrote in message
> news:[email protected]...
> > I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with
> filtering
> > and sorting. Neither function is working with all the selected cells. On
> more
> > than one occassion, I have had to sent a spreadsheet to a co-worker and
> the
> > functions operate correctly. These are simple basic functions for excel
> and
> > there should be no excuse for these not to operate as designed. But what
> > really is indicative of the monopoly abuse exercised by Microsoft, is that
> we
> > users should have to pay in order to get support for such basic functions.
> > This is like buying a new car and having to pay for the 4th tire.
>
>
>

If you use autofilter and it shows you more than one 400 then they are
different. Could be leading or trailing spaces, text vs numeric etc, but
they are different. Check the values carefully.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"dsbiloxi" <[email protected]> wrote in message
news:[email protected]...
> when I attempt to sort all the data, either in ascending or descending
order,
> I will not get always get all the like data grouped together. For example,
I
> want to see all of my estimated man-hours for serveral construction
projects
> by plant systems and there are 10 different systems. When I sort soley by
> column entitled "Plant Systems." I expect to find system "400" all grouped
> together and likewise if I use the "Autofilter" feature and select "400".
But
> this is not happening. I may find "400" all over. I have experiemented
with
> several machine in our office and the only ones that have Excel 2002 and
> operating on XP will give me the correct results. I have downloaded all
the
> upgrades for my Office 2000 and I am still not getting correct results. By
> the way, if I did not clarify this point, please note that none of our
> machines with Office 2000 produced the correct results. Any help is
> appreciated.
>
> "Peo Sjoblom" wrote:
>
> > So now you blew some steam off, what is not working?
> >
> > --
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "dsbiloxi" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with
> > filtering
> > > and sorting. Neither function is working with all the selected cells.
On
> > more
> > > than one occassion, I have had to sent a spreadsheet to a co-worker
and
> > the
> > > functions operate correctly. These are simple basic functions for
excel
> > and
> > > there should be no excuse for these not to operate as designed. But
what
> > > really is indicative of the monopoly abuse exercised by Microsoft, is
that
> > we
> > > users should have to pay in order to get support for such basic
functions.
> > > This is like buying a new car and having to pay for the 4th tire.
> >
> >
> >

thanks Ken but I know this and yes, they are all numeric, I am not an idot,
please find something else to do other than anwering my posts,

"Ken Wright" wrote:

> If you use autofilter and it shows you more than one 400 then they are
> different. Could be leading or trailing spaces, text vs numeric etc, but
> they are different. Check the values carefully.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "dsbiloxi" <[email protected]> wrote in message
> news:[email protected]...
> > when I attempt to sort all the data, either in ascending or descending
> order,
> > I will not get always get all the like data grouped together. For example,
> I
> > want to see all of my estimated man-hours for serveral construction
> projects
> > by plant systems and there are 10 different systems. When I sort soley by
> > column entitled "Plant Systems." I expect to find system "400" all grouped
> > together and likewise if I use the "Autofilter" feature and select "400".
> But
> > this is not happening. I may find "400" all over. I have experiemented
> with
> > several machine in our office and the only ones that have Excel 2002 and
> > operating on XP will give me the correct results. I have downloaded all
> the
> > upgrades for my Office 2000 and I am still not getting correct results. By
> > the way, if I did not clarify this point, please note that none of our
> > machines with Office 2000 produced the correct results. Any help is
> > appreciated.
> >
> > "Peo Sjoblom" wrote:
> >
> > > So now you blew some steam off, what is not working?
> > >
> > > --
> > >
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > >
> > > "dsbiloxi" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I am using Excel 2000 (9.0 6926-SP-3) and I am having problems with
> > > filtering
> > > > and sorting. Neither function is working with all the selected cells.
> On
> > > more
> > > > than one occassion, I have had to sent a spreadsheet to a co-worker
> and
> > > the
> > > > functions operate correctly. These are simple basic functions for
> excel
> > > and
> > > > there should be no excuse for these not to operate as designed. But
> what
> > > > really is indicative of the monopoly abuse exercised by Microsoft, is
> that
> > > we
> > > > users should have to pay in order to get support for such basic
> functions.
> > > > This is like buying a new car and having to pay for the 4th tire.
> > >
> > >
> > >
>
>
>

LOL - a) I beg to differ, and b) Trust me, I will. Have fun.

I will throw you one bone though - just because you hit Format / Cells and
it says numeric, it doesn't really mean it is, but I'll leave you to trawl
the archives and try and find out why.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"dsbiloxi" <[email protected]> wrote in message
news:[email protected]...
> thanks Ken but I know this and yes, they are all numeric, I am not an
idot,
> please find something else to do other than anwering my posts,
>
> "Ken Wright" wrote:
>
> > If you use autofilter and it shows you more than one 400 then they are
> > different. Could be leading or trailing spaces, text vs numeric etc,
but
> > they are different. Check the values carefully.
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "dsbiloxi" <[email protected]> wrote in message
> > news:[email protected]...
> > > when I attempt to sort all the data, either in ascending or descending
> > order,
> > > I will not get always get all the like data grouped together. For
example,
> > I
> > > want to see all of my estimated man-hours for serveral construction
> > projects
> > > by plant systems and there are 10 different systems. When I sort soley
by
> > > column entitled "Plant Systems." I expect to find system "400" all
grouped
> > > together and likewise if I use the "Autofilter" feature and select
"400".
> > But
> > > this is not happening. I may find "400" all over. I have experiemented
> > with
> > > several machine in our office and the only ones that have Excel 2002
and
> > > operating on XP will give me the correct results. I have downloaded
all
> > the
> > > upgrades for my Office 2000 and I am still not getting correct
results. By
> > > the way, if I did not clarify this point, please note that none of our
> > > machines with Office 2000 produced the correct results. Any help is
> > > appreciated.
> > >
> > > "Peo Sjoblom" wrote:
> > >
> > > > So now you blew some steam off, what is not working?
> > > >
> > > > --
> > > >
> > > > Regards,
> > > >
> > > > Peo Sjoblom
> > > >
> > > >
> > > > "dsbiloxi" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I am using Excel 2000 (9.0 6926-SP-3) and I am having problems
with
> > > > filtering
> > > > > and sorting. Neither function is working with all the selected
cells.
> > On
> > > > more
> > > > > than one occassion, I have had to sent a spreadsheet to a
co-worker
> > and
> > > > the
> > > > > functions operate correctly. These are simple basic functions for
> > excel
> > > > and
> > > > > there should be no excuse for these not to operate as designed.
But
> > what
> > > > > really is indicative of the monopoly abuse exercised by Microsoft,
is
> > that
> > > > we
> > > > > users should have to pay in order to get support for such basic
> > functions.
> > > > > This is like buying a new car and having to pay for the 4th tire.
> > > >
> > > >
> > > >
> >
> >
> >

Ken

If the data sorts and filters properly using Excel 2002 and I am assuming, the
same workbook, on other machines, what then???

If not the same workbook, ignore this and let OP trawl.


Gord

On Thu, 10 Mar 2005 23:32:31 -0000, "Ken Wright"
<[email protected]> wrote:

>LOL - a) I beg to differ, and b) Trust me, I will. Have fun.
>
>I will throw you one bone though - just because you hit Format / Cells and
>it says numeric, it doesn't really mean it is, but I'll leave you to trawl
>the archives and try and find out why.
>
>--
>Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
>----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
>----------------------------------------------------------------------------
>
>"dsbiloxi" <[email protected]> wrote in message
>news:[email protected]...
>> thanks Ken but I know this and yes, they are all numeric, I am not an
>idot,
>> please find something else to do other than anwering my posts,
>>
>> "Ken Wright" wrote:
>>
>> > If you use autofilter and it shows you more than one 400 then they are
>> > different. Could be leading or trailing spaces, text vs numeric etc,
>but
>> > they are different. Check the values carefully.
>> >
>> > --
>> > Regards
>> > Ken....................... Microsoft MVP - Excel
>> > Sys Spec - Win XP Pro / XL 97/00/02/03
>> >
>>
>> --------------------------------------------------------------------------
>--
>> > It's easier to beg forgiveness than ask permission :-)
>>
>> --------------------------------------------------------------------------