Does anyone know...

[aly]

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

 

[JE McGimpsey]

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

Do you have a specific question about RANK and LOOKUP?

 

[aly]

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

Do you have a specific question about RANK and LOOKUP?

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

 

[JE McGimpsey]

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?

 

[aly]

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 repeatin
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?

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

 

[JE McGimpsey]

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.