 |
|
|
|
Next: Set up is not a valid Pocket pc application
|
| Author |
Message |
External
Since: Sep 29, 2005
Posts: 1
|
(Msg. 1) Posted: Thu Sep 29, 2005 3:07 am
Post subject: Pocket Excel Function: Rank?
Archived from groups: microsoft>public>pocketpc (more info?)
|
|
|
|
| Does anyone know how to get the equivalent of this Excel function into a
Pocket Excel spreadsheet?
=Rank(A1,A1:A10,1)
Thanks
|
|
|
| Back to top |
|
 | |
|
"Clinton Fitch, Clinton F
|
External
Since: Mar 29, 2005
Posts: 726
|
(Msg. 2) Posted: Thu Sep 29, 2005 3:16 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hello,
Pocket Excel does not support the RANK function unfortunately. However,
SoftMaker's PlanMaker does support it. You can get more information and a
demo of it from SoftMaker at http://www.softmaker.com. You can read a
review of it on my site at
http://www.clintonfitch.com/reviews/softmaker/planmaker-2004/default.asp.
Regards,
--
Clinton Fitch
Senior Editor / Owner
Clinton Fitch (Dot) Com!
http://www.clintonfitch.com
A Pocket PC Magazine "Best Site" for Pocket PC Reviews!
"KMcG" <karen DeleteThis @kmcgarrigle.wanadoo.co.uk> wrote in message
news:%23ZVbqUMxFHA.2228@TK2MSFTNGP11.phx.gbl...
> Does anyone know how to get the equivalent of this Excel function into a
> Pocket Excel spreadsheet?
>
> =Rank(A1,A1:A10,1)
>
> Thanks
> |
|
| Back to top |
|
| |
External
Since: Sep 30, 2005
Posts: 5
|
(Msg. 3) Posted: Fri Sep 30, 2005 12:06 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I suppose you could sort your data into order and then number the
sorted data from top to bottom (or vice versa) being careful to check
for ties.
Lance |
|
| Back to top |
|
| |
External
Since: Sep 30, 2005
Posts: 5
|
(Msg. 4) Posted: Fri Sep 30, 2005 12:29 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
A cheaper, and in some respects (e.g., supports some macro commands)
more comprehensive program is SpreadCE. See
http://www.byedesign.freeserve.co.uk
SpreadCE is also less demanding on your hardware. Planmaker can take a
while to load and can be quite slow.
Lance |
|
| Back to top |
|
| |
|
"Clinton Fitch, Clinton F
|
External
Since: Mar 29, 2005
Posts: 726
|
(Msg. 5) Posted: Fri Sep 30, 2005 4:10 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Lance,
Great alternative and one I didn't think about.
Regards,
--
Clinton Fitch
Senior Editor / Owner
Clinton Fitch (Dot) Com!
http://www.clintonfitch.com
A Pocket PC Magazine "Best Site" for Pocket PC Reviews!
"Lance" <lachenicht.DeleteThis@ukzn.ac.za> wrote in message
news:1128083390.634655.249720@g14g2000cwa.googlegroups.com...
>A cheaper, and in some respects (e.g., supports some macro commands)
> more comprehensive program is SpreadCE. See
>
> http://www.byedesign.freeserve.co.uk
>
> SpreadCE is also less demanding on your hardware. Planmaker can take a
> while to load and can be quite slow.
>
> Lance
> |
|
| Back to top |
|
| |
External
Since: Sep 30, 2005
Posts: 2
|
(Msg. 6) Posted: Fri Sep 30, 2005 6:34 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks, I'll try it out - for my Ipaq HX4700 with "Windows Mobile 2003" do I
download the pocketpc version or windows ce version?
KMcG
"Clinton Fitch, Clinton Fitch (Dot) Com!"
<management.RemoveThis@NOSPAMMINGME.clintonfitch.com> wrote in message
news:enmdzfPxFHA.2728@TK2MSFTNGP14.phx.gbl...
> Hello,
>
> Pocket Excel does not support the RANK function unfortunately. However,
> SoftMaker's PlanMaker does support it. You can get more information and a
> demo of it from SoftMaker at http://www.softmaker.com. You can read a
> review of it on my site at
> http://www.clintonfitch.com/reviews/softmaker/planmaker-2004/default.asp.
>
> Regards,
>
> --
> Clinton Fitch
> Senior Editor / Owner
> Clinton Fitch (Dot) Com!
> http://www.clintonfitch.com
>
> A Pocket PC Magazine "Best Site" for Pocket PC Reviews!
>
>
>
> "KMcG" <karen.RemoveThis@kmcgarrigle.wanadoo.co.uk> wrote in message
> news:%23ZVbqUMxFHA.2228@TK2MSFTNGP11.phx.gbl...
>> Does anyone know how to get the equivalent of this Excel function into a
>> Pocket Excel spreadsheet?
>>
>> =Rank(A1,A1:A10,1)
>>
>> Thanks
>>
>
> |
|
| Back to top |
|
| |
|
"Clinton Fitch, Clinton F
|
External
Since: Mar 29, 2005
Posts: 726
|
(Msg. 7) Posted: Fri Sep 30, 2005 6:34 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hello,
You will need the Pocket PC version.
Regards,
--
Clinton Fitch
Senior Editor / Owner
Clinton Fitch (Dot) Com!
http://www.clintonfitch.com
A Pocket PC Magazine "Best Site" for Pocket PC Reviews!
"PocketPC" <karen.DeleteThis@kmcgarrigle.wanadoo.co.uk> wrote in message
news:eTD%234saxFHA.1168@TK2MSFTNGP15.phx.gbl...
> Thanks, I'll try it out - for my Ipaq HX4700 with "Windows Mobile 2003" do
> I download the pocketpc version or windows ce version?
>
> KMcG
>
> "Clinton Fitch, Clinton Fitch (Dot) Com!"
> <management.DeleteThis@NOSPAMMINGME.clintonfitch.com> wrote in message
> news:enmdzfPxFHA.2728@TK2MSFTNGP14.phx.gbl...
>> Hello,
>>
>> Pocket Excel does not support the RANK function unfortunately. However,
>> SoftMaker's PlanMaker does support it. You can get more information and
>> a demo of it from SoftMaker at http://www.softmaker.com. You can read a
>> review of it on my site at
>> http://www.clintonfitch.com/reviews/softmaker/planmaker-2004/default.asp.
>>
>> Regards,
>>
>> --
>> Clinton Fitch
>> Senior Editor / Owner
>> Clinton Fitch (Dot) Com!
>> http://www.clintonfitch.com
>>
>> A Pocket PC Magazine "Best Site" for Pocket PC Reviews!
>>
>>
>>
>> "KMcG" <karen.DeleteThis@kmcgarrigle.wanadoo.co.uk> wrote in message
>> news:%23ZVbqUMxFHA.2228@TK2MSFTNGP11.phx.gbl...
>>> Does anyone know how to get the equivalent of this Excel function into a
>>> Pocket Excel spreadsheet?
>>>
>>> =Rank(A1,A1:A10,1)
>>>
>>> Thanks
>>>
>>
>>
>
> |
|
| Back to top |
|
| |
External
Since: Sep 30, 2005
Posts: 2
|
(Msg. 8) Posted: Fri Sep 30, 2005 11:45 am
Post subject: Re: Pocket Excel Function: Rank? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks so much for your suggestion
I have downloaded a shareware version of this software and will test it at
the track this weekend, if it works as I expect it to then I'll buy it.
Thanks again everyone
Karen
"Lance" <lachenicht.TakeThisOut@ukzn.ac.za> wrote in message
news:1128083390.634655.249720@g14g2000cwa.googlegroups.com...
>A cheaper, and in some respects (e.g., supports some macro commands)
> more comprehensive program is SpreadCE. See
>
> http://www.byedesign.freeserve.co.uk
>
> SpreadCE is also less demanding on your hardware. Planmaker can take a
> while to load and can be quite slow.
>
> Lance
> |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
PDA