I am using google spreadsheets

I don't know anything about the Google spreadsheet app. I don't know if it's
100% compatible with Excel.

You need to provide more details. Where do you want the results to appear?
The results based on the rank, ok, based on the highest ranks or the lowest
ranks? Are there any duplicate ranks?

--
Biff
Microsoft Excel MVP


"reeveret" wrote in message
...
I am using google spreadsheets and the formulas listed in the documents you
linked to still will not give me what I am looking for. Is there a
specific
formula you know of that will do it? or could you create one with some
info?
I want it to display the text (sheet2 B1:AF1) based on the rankings
of
sheet3 B3:B33

"T. Valko" wrote:

See this post in Google Groups:

http://groups.google.com/group/micro...d8708b5?hl=en#

--
Biff
Microsoft Excel MVP


"reeveret" wrote in message
...
I need an if, then formula that will display sheet 2 B1 if sheet3 B3=
sheet
2
B32, but I also need it to have a range of displays that if could
equal.
Basically I have a sheet of numbers that add up and increase each day
for
a
list of stores and I need to rank the totals (which I have done) now
that
the totals are ranked, the spreadsheet is displaying the totals
(numbers)
ranked and I need it translate those numbers into the title of the cell
they
are the totals for(B1, C1, D1, etc.)