Does anyone know...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aly - 19 Feb 2007 15:24 GMT

Hey does anyone know how to use RANK and LOOKUP functions?? please help
many thanks! Aly

Signature

aly

Reply to this Message

JE McGimpsey - 19 Feb 2007 18:37 GMT

There are many here that do. Have you looked at the examples in Help?

Do you have a specific question about RANK and LOOKUP?

> Hey does anyone know how to use RANK and LOOKUP functions??

Reply to this Message

aly - 21 Feb 2007 08:47 GMT

JE McGimpsey;453162 Wrote:

> There are many here that do. Have you looked at the examples in Help?
>
> Do you have a specific question about RANK and LOOKUP?
>
> -
> > Hey does anyone know how to use RANK and LOOKUP functions??-

no i just want to know how i would put in formula for a spreadsheet i
making

--
aly

Reply to this Message

JE McGimpsey - 21 Feb 2007 13:14 GMT

> no i just want to know how i would put in formula for a spreadsheet im
> making.

If you can't use the Help examples for a pattern, then you need to
describe your situation a bit - otherwise one would be just repeating or
modifying that generic-type example.

For instance, specifically what kind of data do you have? how is your
data laid out? What kind of results are you looking for?

Reply to this Message

aly - 23 Feb 2007 11:38 GMT

JE McGimpsey;454316 Wrote:

> -
> > no i just want to know how i would put in formula for a spreadshee
[quoted text clipped - 8 lines]
> For instance, specifically what kind of data do you have? how is your
> data laid out? What kind of results are you looking for?

Oh well, im making a spreadsheet for our housepoint system for my A
ict coursework and we need to include RANK and LOOKUP. We have used i
before but i don't know how i can use it fro this. I was thinking mayb
it would work for looking up the houses. (LOOKUP) do you think that'
possible?? and i think i know how to use RANK now as i have done it
Write back! Many thanks

--
aly

Reply to this Message

JE McGimpsey - 25 Feb 2007 04:58 GMT

> Oh well, im making a spreadsheet for our housepoint system for my AS
> ict coursework and we need to include RANK and LOOKUP. We have used it
> before but i don't know how i can use it fro this. I was thinking maybe
> it would work for looking up the houses. (LOOKUP) do you think that's
> possible?? and i think i know how to use RANK now as i have done it.
> Write back! Many thanks!

Sure it can be done, but you're not very specific about what 'looking up
the houses' means, so it's hard to say how LOOKUP would be used.

Reply to this Message