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.)

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.)

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.)

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.)

Yes there are duplicate results, they need to be ranked from highest to
lowest, and I want the answer (text from sheet2 B1:sheet2AF1) to appear in
sheet3 C3: sheet2 C33

"T. Valko" wrote:

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.)

Ok, I don't fully understand your setup and how things are related.

sheet2 B1:sheet2AF1 = store names

sheet3 B3:B33 = rankings

How do the ranks relate to the store names?

Is sheet3 B3 the rank for the store in sheet2 B1
Is sheet3 B4 the rank for the store in sheet2 C1
Is sheet3 B5 the rank for the store in sheet2 D1

???


--
Biff
Microsoft Excel MVP


"reeveret" wrote in message
...
Yes there are duplicate results, they need to be ranked from highest to
lowest, and I want the answer (text from sheet2 B1:sheet2AF1) to appear
in
sheet3 C3: sheet2 C33

"T. Valko" wrote:

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.)