Greatest Value Formula

**Andyb43** · 05-10-2011, 11:09 AM

Hi,

I am putting together a register and would like the register to look at the values on a given row, determine which is the greatest and report it in a cell. The problems I'm having are:

1, I'm a complete Excel novice when it comes to using the more advanced Excel functions

2, I need it to be able to differentiate that P2 is greater than P1 etc. (Is this possible)

Would any of you guys be able to put me a formula together or point me in the right direction? Any help would be greatly appreciated. In the meantime I will be trying to improve my Excel skills LOL.

Thanks,

Andy

**NBVC** · 05-10-2011, 11:14 AM

The MAX function reports largest value of a range....

If the issue is more complex, then please post a sample workbook...

click the paperclip icon in the reply box.

**Ron Coderre** · 05-10-2011, 11:24 AM

Try this example....

Please Login or Register  to view this content.

and
E1: a rank to find...e.g. 1 (to find the largest)

This regular formula returns the "largest" text value in that range

Please Login or Register  to view this content.

In the above example, the formula returns: P3
If you change E1 to 2...to find the 2nd largest, the formula returns: P1

Is that something you can work with?