Diasplay string dependant on MAX value

rawky1976 · May 8th, 2002, 07:02 AM

I have five values in separate cells, I find the maximum value. I want to display a word dependant on which is the MAX, instead of the MAX itself.
Also if two cells are equal MAX I need to display two words.

Asala42 · May 8th, 2002, 07:16 AM

G'day,

I'm not sure on the exact output you're looking for. If you have 2 equal max values in the range do you want a formula to output the text "MaxMax"? What if there are 3 equal max values?

Can you give us some further detail?

Adam

rawky1976 · May 8th, 2002, 07:25 AM

I don't want to display MAX, I just meant it to be short for maximum sorry!
Let's say there are five shops, I add up the weekly figures, find the shop with the highest sales, but instead of displaying the figure, I want to display the name of the shop. If two shops have equal sales I need two names displayed.
Thanks

Rocky E · May 8th, 2002, 07:29 AM

But what if three are equal or all five for that matter. Have you considered sort or rank?

Aladin Akyurek · May 8th, 2002, 07:38 AM

Quote:

On 2002-05-08 06:02, rawky1976 wrote:
I have five values in separate cells, I find the maximum value. I want to display a word dependant on which is the MAX, instead of the MAX itself.
Also if two cells are equal MAX I need to display two words.

Have a look at a contrib of mine at:

http://www.mrexcel.com/board/viewtop...c=3146&forum=2

May 8th, 2002, 07:29 AM	#4
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	But what if three are equal or all five for that matter. Have you considered sort or rank? __________________ Hope this helps! Rocky <h6>"Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744).</h6>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 07:02 AM	#1
rawky1976 New Member Join Date: May 2002 Posts: 3	I have five values in separate cells, I find the maximum value. I want to display a word dependant on which is the MAX, instead of the MAX itself. Also if two cells are equal MAX I need to display two words.

May 8th, 2002, 07:16 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,029	G'day, I'm not sure on the exact output you're looking for. If you have 2 equal max values in the range do you want a formula to output the text "MaxMax"? What if there are 3 equal max values? Can you give us some further detail? Adam

May 8th, 2002, 07:25 AM	#3
rawky1976 New Member Join Date: May 2002 Posts: 3	I don't want to display MAX, I just meant it to be short for maximum sorry! Let's say there are five shops, I add up the weekly figures, find the shop with the highest sales, but instead of displaying the figure, I want to display the name of the shop. If two shops have equal sales I need two names displayed. Thanks