is there a way of displaying 2 equal results?

beastwood · May 5th, 2002, 12:45 PM

im using index and match commands..

however it displays the right result in this case the highest of 4 cells..however it will not display more than one when two results are equal...

Yogi Anand · May 5th, 2002, 01:09 PM

Quote:

On 2002-05-05 11:45, beastwood wrote:
im using index and match commands..

however it displays the right result in this case the highest of 4 cells..however it will not display more than one when two results are equal...

Hi beastwood:
How about if you post some sample data and the formula(s) you are using!

Regards

Yogi Anand

beastwood · May 5th, 2002, 01:29 PM

=INDEX(C7:G7,MATCH((MAX(C18:G18)),C18:G18,0))

the above is my formula..as u can see there are 5 possible results but it only displays one at a time..im trying to get it to display 2 or more eg if both c8 and c9 are the highest..

Aladin Akyurek · May 5th, 2002, 01:40 PM

Quote:

On 2002-05-05 12:29, beastwood wrote:
=INDEX(C7:G7,MATCH((MAX(C18:G18)),C18:G18,0))

the above is my formula..as u can see there are 5 possible results but it only displays one at a time..im trying to get it to display 2 or more eg if both c8 and c9 are the highest..

Try my contrib from:

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

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

May 5th, 2002, 12:45 PM	#1
beastwood New Member Join Date: May 2002 Posts: 16	im using index and match commands.. however it displays the right result in this case the highest of 4 cells..however it will not display more than one when two results are equal...

May 5th, 2002, 01:29 PM	#3
beastwood New Member Join Date: May 2002 Posts: 16	=INDEX(C7:G7,MATCH((MAX(C18:G18)),C18:G18,0)) the above is my formula..as u can see there are 5 possible results but it only displays one at a time..im trying to get it to display 2 or more eg if both c8 and c9 are the highest..