How to find out Max Price

[rush2rajen]

Hi Excel Guru,

Please help.
I Need To Know What Is The Max Price Of A Test Code Along With Which Centre ( Need Centre Name ) and by how much more from the Centre ABCD. ( Here Abcd, Efgh, Ijkl Are All Centre Where Abcd Is The Main Centre )

Thanks
Raj

 

[Somendra Misra]

Hi Raj,

Try below formula in I2 and copy down:

=MAX(D2:H2)&" of Centre "&INDEX($D$1:$H$1,,MATCH(MAX(D2:H2),D2:H2,0))&" with a difference of "&MAX(D2:H2)-B2&" from Centre"

Note this will not be able to handle duplicate max values for say two centre.

Regards,

 

[rush2rajen]

Misraji,

Its working. Thanks a lot.

Thanks
Raj